Long time querying from Oracle?

  • Thread starter Thread starter MarkD
  • Start date Start date
M

MarkD

I am running a query from two different programs:
Access2000 and SQLNavigator (a GUI querying tool -- among
other things -- that we use to link to Oracle).

The query is "select companyname from companylist" and I
am getting all the records.

In SQL Navigator, fetching all the rows takes about 3
seconds. In Access 2000, it takes over a minute.

What's the reason it takes Access longer to query the data
and is there a way to speed it up?

Thanks!
-Mark
 
What's the reason it takes Access longer to query the data
and is there a way to speed it up?
Click to expand...


Probably a limitation of ODBC. Have you tried using a PassThrough query?
 
-----Original Message-----


Probably a limitation of ODBC. Have you tried using a PassThrough query?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Click to expand...

Thanks for your input Lynn,

Funny you mention that... I just read up on passthrough
queries and tried my very first one. It's still taking
much longer than when I copied the same statement to SQL
Navigator and ran it there.

Any ideas?

-Mark
 
Mark,
I would have to assume it's because SQL navigator has a direct connection to
the Oracle database. You might look into doing a DNS-less connection for
your queries. Do a google search and you should get some good responses on
that.
 
Back
Top