PAINFULLY slow query to linked tables!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

Could you perhaps give us a slight clue at what these queries actually
DO? such as posting the SQL?


John W. Vinson[MVP]
 
Back
Top