Quote Originally Posted by jmarcv View Post
I Managed a server that did a lot of REGEXP on datasets of up to 10,000 records withing a query set that had to be examined, with some 200-800 queries per second, so unless your even within 20% of that even on a shared server, I don't think it will be noticable.
I dont think it will come close to that.

The search is carried out in 4 fields in just under 550 records. It searches product name, manufaturer, description and model. It does this for each term that is entered into the search box either the exact term if it is in "" or by using AND or OR. I guess the only problem i could see is if someone maliciously decided to put a huge search term in

200-800 queries per second!! Blimey! Although thinking about it if you take all the queries into account on the site and the access database that links into the sql database i reckon i must be one at least 1 query per second! Whoop Whoop!