Long time querying from Oracle?

[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

 

[Lynn Trapp]

What's the reason it takes Access longer to query the data

and is there a way to speed it up?

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

 

[MarkD]

-----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

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

 

[Lynn Trapp]

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.