One thing you can do is add a default where clause so that the database doesn't return any rows before filtering with the search field. This is done by adding 0=1 to the default search clause in the Database Search server behavior.
Another thing that might make sense is to set a maximum number of rows to display on the page and add pagination. Maybe show 20, 50 or even 100 rows on one page with next and previous page links.
For now I've just added the default where clause to the page to allow it to load and that might be enough for this page.
Well noted and thanks for the information, I followed and works fine. Meanwhile I could not figure out one matter and I need your guide here because I am very much new with your tools.
What I am trying to do is:
Only one search input filed should work for partial match and exact match. For exact match I want to put a check box so that when the checkbox is checked it should perform exact match and if the checkbox is not checked then it should perform a general partial match search.
Pls help me to figure it out, Thanks a lot for your great support!