ODBC - needs must as the devil drivers

Hi again,

This is my third newbie question to the oracle set of groups, so I hope people still feel like writing, thanks for the responses so far.

This one concerns ODBC, in particular why both the ORACLE and Microsoft drivers for Oracle seem to be so slow. I am connecting to Oracle8 using attached tables thru ODBC, the driver is the ORACLE 32 bit driver although I have also tested using the MS driver.

The main problem seems to become apparent when I compare 2 queries between native MS Access(2.0) and ODBC attached tables to the access db.

(I can send the SQL for these queries if anyone is interested)

QUERY 1

6 tables with inner joins but no function calls in the results, simple field returns.

    MS Access                                 10 seconds

    Oracle ODBC thru MS access     6 seconds.

QUERY 2

4 tables with inner joins. Has calls to access Dateserial function, and a pretty complex calculation which is repeated in the where clause.

   MS Access                                    7 - 10 seconds

    Oracle ODBC thru MS access     1 minute 20 seconds.

WHOAH!!! That is a big difference in query 2!

My theories are :

            WHAT AN IDIOT! Use PL/SQL at the server end you dolt!
                        - I should have the entire query at the server
end
                        - I should have the functions i mentioned at the

            My Driver Sucks....bigtime. and I should buy a nice expensive Driver that'll work way better

            Thats all I can think of really...any suggestions.

Please Email me with your comments as well!

Robin. Received on Fri Nov 21 1997 - 00:00:00 CET