Customized search form being slow
Posted on 2002-03-30
Since a while i used customized search form to search my database in the webinterface. The main purpose was to create a complete application , with same look-and-feel all over.
Now i got several complaints about the searches being slow to to display using the customized Search form ( $Search form and $$Return field with the search string ) in comparison with the standard common search form.
I did the test and in fact the first solution is taking a lot of time the first time it was called , new searches after this are faster.
Since the custom search uses a distinct view , i thought that every time the search was called , there was a reindex of the view.
Are there any idead on how to make the custom search at least as fast as the common search ( which uses no distinct vies , afaik )