Hi David,
I have added a lot of items to my database so it is more than 100,000 products. Now the load time is very slow. Is there anything I can do to make it faster?
Regards
Roland
Sorry to butt in , but I have the old search (which works very very well) but I have 500,000 products and as you have said the search is slower , is there any way to speed the search up ? (apart from switch back the search.php file)
thanks
Hi Jonny,
The old search requires a full table scan, so the only way to speed it up is my checking your MySQL configuration as discussed in the thread referenced above; or of course faster hardware. Look for the configuration options first of course...
Cheers,
David.
Hi Roland,
Check out the following thread for discussion about MySQL config for large sites...
http://www.pricetapestry.com/node/732
In general, the older search method (only used for queries less than 4 characters) will get slower as you approach that number of products, but full text queries (the majority) should be reasonably quick still...
Cheers,
David.