Linked Table

  • Thread starter Thread starter Saz
  • Start date Start date
S

Saz

Hi Group,

My Link Table is almost 500 MB with more than 230K rows. So to run
even a simplest query it takes forever to get the result. How can I
solve this problem? To make it worst I have a Macro that runs like 6/7
queries at once so it takes like an hour via VPN/wireless to complete
this one Macro.

Thank you, Saz
 
Saz said:
Hi Group,

My Link Table is almost 500 MB with more than 230K rows. So to run
even a simplest query it takes forever to get the result. How can I
solve this problem? To make it worst I have a Macro that runs like 6/7
queries at once so it takes like an hour via VPN/wireless to complete
this one Macro.

Thank you, Saz
Click to expand...

Can you post the SQL for each of the queries to give us a better idea what
they are doing?

Your problem *may* be one of indexing on the tables. If this is not done
correctly it will have a dramatic effect on performance. Posting the SQL
will allow us to give you an idea on which fields to index.

Another cause may well be the bandwidth of the network you are connecting
over. Access likes *plenty* of network badnwidth (and a rock-steady
connection). If this is the source of your problem there may not be anything
we can do other than suggest a fast connection or an alternative database
engine.

Ed Metcalfe.
 
Hi Group,

My Link Table is almost 500 MB with more than 230K rows. So to run
even a simplest query it takes forever to get the result. How can I
solve this problem? To make it worst I have a Macro that runs like 6/7
queries at once so it takes like an hour via VPN/wireless to complete
this one Macro.

Thank you, Saz
Click to expand...

Appropriate indexing on the query - i.e. indexes on the field or fields you're
using for criteria or for sorting - will make a dramatic difference in speed.
You chose not to post any details of the queries, so it's more than a bit
difficult to suggest how the individual queries might be improved.

Are these select queries? Action queries such as appends, deletes, updates? A
combination? More details please. For instance, if there are certain types of
action queries adding an index might make things WORSE since you must not only
update the table and write it to disk, but also update the Index and write
*it* to disk!
 
Back
Top