• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Saved Query too slow

xxpeta

Active Member
Hi All,

I have some trouble with functionality Saved Query in my custom application. When I use QBE for filtering records, it runs quickly. But when I use the functionality Saved Query to save the same query as I made via QBE, it tooks few minutes to get result. It looks like this functionality is not selecting but hiding records.

The view is quite complicated, because there are 2 standard tables and 1 fake table (SQL view with union from 2 tables).

Do you have any idea to make it faster?

Thanks for your replies.

Petr
 

David Robertson

Reputable Poster
I would start by turning on debugging and checking what the differences in the SQL being generated are.

I haven't made a lot of use of the save query functionality, but I had assumed as you have, that it was simply saving the QBE settings.
 
Top