PAINFULLY slow Query of linked tables??

[Rousseau10]

I am querying actual flat text files our company calls a database using access 2000. The company has similar file schemas on different drives so to get similar data for a our clients we have to run the exact same query on mulitple drives IE I have 10 different queries that are the same schema but link to a different database we will say. In code I run these queries and append them to a table.

docomd.openquery ("1")
docomd.openquery ("2")
docomd.openquery ("3")
docomd.openquery ("4")
etc...

It finishes the first 2 queries in about 5 sendonds but then takes 30 mintus for the 3rd and 2 hours then I dies on the 4th. But all queries are similiar. I know traffic and size of query accounts for longer times, but 5 seconds for 1 and 2 then 2 hours for 4???

Any Ideas why. I am connect via ODBC

 

[jgoodman00]

Approximately how big are the text files & how many rows?

Do the different network shares perform equally?



James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[mikej336]

You would not query a flat text file or use odbc. You would need to connect to a database of some kind. If you are querying an Access table you still are useing Jet. Do you know that type database/file you are connecting to.

Are the files and I assume different computers, all on the same LAN or are some remote (as I suspect). If so you might be better off to run your query remotely and copy a file back with the data.

Uncle Mike

 

[Rousseau10]

I am query a company from a company database in a different City. We use 'Relativity" as the datasource using an ODBC connection.
I am told the database is actually flat files but split into different shares.
I tried running the access program from another computer and it worked!!! But the 5th share took forever and seem to be hung so I did a control break and moved on, I will Isolate that and relink to see if I can get it to work too. Thanks for the help!!!