Oracle ODBC performance SUCKS!@

Two identical tables: one in MS SQL Server, the Other in Oracle 8 NT. (NT Server 4.0 SP3, 96 MB RAM, PII 266, SCSI Wide 4-g. Stripped system of no other extraneous applications, processes.)

Access 97 linked tables via ODBC (BOth Microsoft ODBC drivers, one for oracle, the other SQL Server.)

Loading a page full of data from the Oracle 8 server causes my one-user load NT server performance to sky rocket to 97% for three seconds just to pull back a pagefull of data in MS Access via ODBC from the Oracle 8 Server.

Using the same linked table(exact schema) but MSAccess to MS Sql Server results in a page of data coming in less than 1 second and NT performance monitor shows 2% utilization on the processor for this test.

Now I know that this is informal and not scientific. But , Oracle Sucks!

Every time I hit page down in MS access via ODBC to Oracle 8 it takes three to four seconds per page of data. In MS Sql server it's pretty much instantaneous.

By the way, I ran each test on the server while only one database server process was running(ie., Oracle 8 Alone on the server, then MS SQL Server alone on the server.

What the hell is going on?

How can somebody reliably develop with ODBC and Oracle 8? With 1 user Oracle 8 is brought to it's knees!

I have Oracle 8 running in the default configuration but with 30mb SGA.

I absolutely have to know if I can tweak Oracle 8 into a usable system for a VB5 to Oracle 8 application via ODBC. If not, I have to explain to my customer to switch to MS SQL(they already own oracle 8).

I can't imagine running a 100-user + system on Oracle 8. What's all the hubbub about Oracle 8 anyway. Does it just suck on NT or what?

brittonb_at_webt.com Received on Fri May 01 1998 - 17:32:42 CDT