Slow performance of linked dbs

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

Guest

The UNC looks something like this \\serverlevel1\serverlevel2\folder1\filename.mdb. Does this address have something to do with extreme slowness searching. Select query is looking for all active records for assigned to a specific person.
 
If you are running a query that is searching a table for certain records,
and the query is running very slowly, this would suggest that the relevant
field(s) have not been Indexed, and/or, the table has not been properly
designed.

What is the structure of the table being searched, and what is the SQL that
you are searching it with?

HTH,
TC


Denise said:
The UNC looks something like this
Click to expand...
\\serverlevel1\serverlevel2\folder1\filename.mdb. Does this address have
something to do with extreme slowness searching. Select query is looking
for all active records for assigned to a specific person.
 
For a list of the issues you might try, take a look at Tony Toews
"Performance FAQ":
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Denise said:
The UNC looks something like this
Click to expand...
\\serverlevel1\serverlevel2\folder1\filename.mdb. Does this address have
something to do with extreme slowness searching. Select query is looking
for all active records for assigned to a specific person.
 
Thanks. I ran Access performance tool and it make some changes to relationships and indexes. So tomorrow when I test on client's network, I hope to see some improvement. Thanks again.
 
Back
Top