Slow

[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

 

[Jeff Boyce]

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>

 

[Jeff Boyce]

Antony

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

Jeff Boyce
<Access MVP>