![]() If the performance remains the same, I can say with some confidence that the app is the problem. ![]() You should be able to verify this by swapping in either the Microsoft ODBC for Oracle driver or the Merant ODBC driver for Oracle. This option essentially determines how many rows ahead we should fetch.ĭo you have access to the code that's making the ODBC calls? I suspect that the root of the problem will be in inefficient calls being made to the ODBC driver. You could try increasing the "Prefetch Count" setting in the ODBC DSN to see if that helps matters. And 99% of the time consumed on 'data retrieval'. In SQL Worksheet, the data (800 rows) came back in 1 second, through ODBC it took 40 to 100 seconds. ![]() Slow performance with oracle 8.1.6 ODBC Drivers - ODBC I am trying to trouble shoot a performance problem with Oracle ODBC driver.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |