2 Replies Latest reply: Oct 23, 2012 9:51 AM by Ralf Becher RSS

    How to optimize the slow reloading/fetching of data thru ODBC-oracle?

      Hi,

       

      I'm stuck here. I'm already connected to Oracle database via ODBC. But the problem is that, fetching of data takes so slow, 200,000 rows takes 30mins? This is not ideal. How to optimize this problem? Please let me know. I need the answer asap.

       

      DOES LOCATION OF THE SERVER/DATASOURCE AFFECTS? I guess so.

       

      Thanks,

      Bill