Stock Level display slow

[Simon]

i have a telephone ordering systems, all works fine trying to find the
best way to dispaly the stock level, what ever i do it takes a long
time to load the big query, any one got and good idea on how to speed
up stock level query

 

[John W. Vinson]

i have a telephone ordering systems, all works fine trying to find the
best way to dispaly the stock level, what ever i do it takes a long
time to load the big query, any one got and good idea on how to speed
up stock level query

Correct the erro(s)r in the design of the table, the query, or the indexing of
the database, I'd guess.

I cannot see how anyone can help you do so without at least *some* information
about the structire of your tables, or of the stock level query, or how you're
loading it. Could you give us a hand here?

 

[Tom van Stiphout]

On Sun, 20 Jun 2010 14:26:38 -0700 (PDT), Simon <[email protected]>
wrote:

You didn't tell us how you're doing it, but if you are processing all
transactions since "day 1" when you started the app, you're doing way
too much work.
Rather it is common to have a StockTake table where you enter
quantities available from time to time, and then you only have to
process transactions AFTER that date.
Good indexing should help as well. Check your table design, especially
the fields you're using in a WHERE and ORDER BY clause.

-Tom.
Microsoft Access MVP