Form Performance Query

[Guest]

Hi all,

I have a form that is based on an Union Query that is quite complex and
slow. Within that form, I also have many combo boxes and 2 graphs also
linked with that union query.

Would you have any advise to give me to speed up the form?

I was thinking to create a temporary table with the values from the union
query but I am not sure I should go there...

Thanks for your help.

 

[Guest]

Cx union queries can be slow. Queries perform best when pre-compiled but this
is not always possible. If you have graphs hanging off it you obviously use
it at least occasionally. Consider using a Parameter Query.

Creating temp tables is very messy and causes db bloat which needs to be
cleaned up; so temp tables are a very last resort.

Union queries often result (not always) from an incorrectly structured db.
Have a look at your structure and read up on Normalisation.
HTH - even a little
Terry