Hello there,
I have an issue that I hope someone will be able to point me in the right direction. I have an orders table and I am using a "list page with search" to populate the customer id from a customer lookup table. The customer lookup table has over 2 million records in it so it is a little bit slow. I have tried to speed up the query by adding indexes to the table and unticking the columns that I do not need it to search. When I first click on the "select" link it takes about 3 seconds to load the list page with search which is fine. When I then search for a name it takes about 20 seconds which again is fine because there is a loading splash screen so the users can see it is doing something. However if I close the list page with search and click the select link again it takes 20 seconds to load the last search query without a splash screen, this is confusing to users why think this is running slowly. How can I get it so that it does not save the search query? Or how do I get it is so that each time the the list page with search resets the search query (the equivalent of pressing the show all button)
I suspect the answer might be an event but I am not sure. I have read through the manual and searched this forum but I could not find the answer. Please can someone help me.
Richard