Slow query

[kenkcj]

Hi everyone,
There is a database that is shared over the network that several users all
use on a daily basis. There are several tables and queries. There is one
user that only uses one query and lately she's concerned because its been
running fairly slow. There are a few other users that use that query as
well, and she was curious if we created a seperate query that has all the
same links and data that she uses if it would speed things up. Being that
they would both be linked to the same tables, I didn't think that it would
be any different, but I told her that I would find out. If anyone has any
opinion or knows anything related to this problem, please let me know. Thank
you.
-kenkcj

 

[John W. Vinson]

Hi everyone,
There is a database that is shared over the network that several users all
use on a daily basis. There are several tables and queries. There is one
user that only uses one query and lately she's concerned because its been
running fairly slow. There are a few other users that use that query as
well, and she was curious if we created a seperate query that has all the
same links and data that she uses if it would speed things up. Being that
they would both be linked to the same tables, I didn't think that it would
be any different, but I told her that I would find out. If anyone has any
opinion or knows anything related to this problem, please let me know. Thank
you.
-kenkcj

If you have a multiuser database, it's very important to "split" it so each
user has *THEIR OWN* copy of the frontend, containing all the queries, forms,
reports, etc; the tables would be linked in a shared backend database.

See http://www.granite.ab.ca/access/splitapp.htm for details, or do a Google
Groups search of these newsgroups.

Has the database been Compacted? This can reset and improve the query plan and
optimize the disk storage, making some queries faster.

John W. Vinson [MVP]

 

[Brendan Reynolds]

Hi everyone,
There is a database that is shared over the network that several users all
use on a daily basis. There are several tables and queries. There is one
user that only uses one query and lately she's concerned because its been
running fairly slow. There are a few other users that use that query as
well, and she was curious if we created a seperate query that has all the
same links and data that she uses if it would speed things up. Being that
they would both be linked to the same tables, I didn't think that it would
be any different, but I told her that I would find out. If anyone has any
opinion or knows anything related to this problem, please let me know.
Thank you.
-kenkcj

No. A more fruitful area for investigation would be to examine whether
indexes are being used appropriately, for example are all fields used in the
WHERE clause and ORDER BY clause indexed, for example, and is the query
designed to make use of those indexes.