Slow RWOP Query

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

Kahuna

Hi Folks

I have a linked table from a secured database. I have a form based on a RWOP
query to the linked table.

With 1, to say, 50 records the performance is as you would expect, but with
more records it becomes progressively slower to open, with several seconds
taken at 99 records.

The linked table (database) is in the same directory as the front end so
there is no network significance.

Any suggestions on where I need to look for problems.
 
-What's the criteria?
-Is there a Union involved?
-How many functions? IIF(), etc.
-Do you have indexes on pertinent fields?
-Is the * used, instead of a limited field list?
-Are there other controls on the form that are loading(like combo's or
subforms) that can wait to be loaded when the user clicks on them?
 
Steve - responded to your questions below. Thanks for the help.
-What's the criteria?
Click to expand...
Its a filter form so the criteria can vary
-Is there a Union involved? No

-How many functions? IIF(), etc. None

-Do you have indexes on pertinent fields? Yes

-Is the * used, instead of a limited field list?
Click to expand...
* used
-Are there other controls on the form that are loading(like combo's or
Click to expand...
Yes, but same combo's used on a similar form loading from a linked table
directly and that runs fine (no load lag)
subforms) that can wait to be loaded when the user clicks on them?
Click to expand...
No Sub Forms
 
Using the * is a known slow method. Try replacing with a strict set of
field names.
 
Cheers Steve - I have tried that since and have no speed change. I am going
to rebuild the entire linked Db and re-run it.

I used the * as a convenient method because the linked table is changing
regularly at the moment, and this is just one more thing that needs to be
remembered to update in the Front End - but, needs must...!

Thanks
 
Back
Top