I THINK is bc I have big queries that takes longer to compile so when someone enters a value and then click on search it takes a while for the program/computer to process because of the big and different inefficient join query that cause the second screen to pop behind.



I alter the query I hope this helps. I am monitoring it.

If it does not help I will make a replicate with dummy data and forward your way.