2000+ doc slow database search

One of my clients has a large site consisting of more than 2000 resources and unfortunately the AjaxSearch seems to timeout when conducting a searchs.

I have tried limiting the search by adding &whereSearch=`content:introtext` but to no avail, this hasn’t helped at all.

Can anyone suggestion alterative ways to refine and fix our search issue.

Thanks.

Google?

http://davidwalsh.name/google-ajax-search

Could you add &debug=`1` in your snippet call, run a search as usual, open the debug/ajaxSearch_log.txt file, search the SQL order inside the file and then copy/paste this order in phpMyAdmin.
By doing this, you re-run the sql order directly inside MysQL. What are the results ? how long takes the request ? How many results ?

Don’t forget to unset the debug parameter after this test.

Thanks for the advice, is AjaxSearch capable of searching 1000s of resources or have I just met the limits in whats possible?

Thanks for the advice, is Aja

xSearch capable of searching 1000s of resources or have I just met the limits in whats possible? [/quote]To be honest, I don't know the limits. With a simple search (without a search in TVs) like &whereSearch=`content:content`, the limits depends of:
- the number of ressources to search in and of your mysql server performances
- the number of results found
- the number of results displayed (ajaxMax or grabMax parameter)

Otherwise a parameter named timeLimit has been added with the 1.9.0 version:

---- &timeLimit = [ int | 60 ]   (optional)
        &timeLimit = [ int | 60 ]
        Max execution time in seconds for the AjaxSearch script  
        0 - If set to zero, no time limit is imposed
        Default: 60 - 1 minute.

Try to change it by adding &timeLimit=`0` or an upper value than 60.