Re: NewBie question: 9i query runs slower than same query on 8i?

Thanks for your replies, but maybe I didn't explain it well enough...

The Oracle 9i database on another machine hasn't changed.

The application hasn't changed.

When I installed the 8i ODBC driver in my local box the query runs
well.

When I install 9i ODBC driver on my local box the query is 'about' 5
time slower.

To my thinking it must be the local ODBC driver configuration.
I there some non-out-of-the-box configuration I would need to do.

.

Relevant Pages

  • RE: ORACLE DRIVER
    ... Subject: ORACLE DRIVER ... DBI - is the perl module to handle all the request of the database, ... So is there any free Oracle ODBC driver for Linux? ...
    (perl.dbi.users)
  • MS ODBC w/UTF8 & Oracle 10g database NULLS char fields > 1024 char
    ... IF fields over 1024 characters in size are edited using a record set: ... AND that Oracle 10g database has been set to use UTF8 encoding ... If you use the Oracle ODBC driver rather than the MS ODBC driver. ...
    (microsoft.public.data.odbc)
  • Re: Convert db Oracle 7.0 to 10g
    ... database in Oracle 7.0 to a new accounting software. ... All you need is an ODBC driver. ... But my main problem is to find the ODBC for the Oracle 7.0 version... ...
    (comp.databases.oracle.server)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 Serve
    ... I am using the Microsoft's ODBC Driver for Oracle ... >string cannot be found in the tnsname.ora file. ... >the database using a simple SQL query. ...
    (microsoft.public.inetserver.iis)
  • Re: Process wont die when form is closed.
    ... The database is a Pervasive v.9 with an ODBC driver. ... The DataGridView works great except when I'm done and I click the X to close ... Or is the background thread just an automagic thing and I have to insert the IsBackground property somewhere in order for the code to shutdown properly? ... In this case it means that the code is stucked in the main thread, probably in the Pervasive ODBC driver. ...
    (microsoft.public.dotnet.languages.csharp)