Slow

  • Thread starter Thread starter antgel
  • Start date Start date
A

antgel

Hi all,

There is one particular query in my database that is excrutiatingly slow.
There are various DSums, JOINs, and ADO function calls involved in the mix.
:) Anyone got any tips on how to start debugging this type of thing?

I can post the queries if someone is willing to have a look?

Antony
 
Where to start... <g>!

Anytime a query includes a call to a back-end, AND functions that can only
run locally, it will slow down, as the entire recordset needs to be brought
in before the local functions can run.

A first suggestion would be to eliminate ALL functions, and simply get the
minimum set of data back. Then, build a second query, based on the result
set of the first, and include local functions.

Good luck!

Jeff Boyce
<Access MVP>
 
Antony

OK, I think you're right ... it's time to post the SQL of your query...

Jeff Boyce
<Access MVP>
 
Back
Top