performance optimization query with V.B. 6.0 as front end.
393309Apr 26 2003 — edited Apr 27 2003Hi! Everybody ,
we are getting very slow speed when we connect our v.b. form to oracle database using adodb 2.1 in aduseclient mode(cursor location). The performance significantly improves when we use aduseserver mode.
The performance with the native database i.e. ACCESS is satisfactory in both the cursor locations.
Kindly suggest solution to performance improvement with Oracle 8e