Riverton Studios Posted February 20, 2009 Share Posted February 20, 2009 I have an issue with the site search. It is very slow. Actually, most of the time the page just times out while searching. Does anyone know a quick fix I can make to search.php so it runs faster searches?My site is http://www.rivertonstudios.com/shopTo test it just type in any band or artist. I sell movies and music on the site.Thank you in advance.P.S. If it makes a difference... I have found that if I do a search, the page will fail while loading. But if I do the same search maybe 3 or 4 times, it will eventually show me my results. Link to comment Share on other sites More sharing options...
TropischBruin Posted February 20, 2009 Share Posted February 20, 2009 We already know your site is slow thus saying that your search is slow would have made more sence in you other topic then to start a new one.Also working on a solution in 2 topics is something not-done, please keep all you questions about the slowness of you site in your other topic.Thanks! Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2009 Share Posted February 20, 2009 How many products do you gear from your shop? Link to comment Share on other sites More sharing options...
Damien Metzger Posted February 20, 2009 Share Posted February 20, 2009 Your website takes 2 or 3 times more time to answer a GET request than any other PrestaShop I know, so the search isn't the problem, it only emphasis it. Link to comment Share on other sites More sharing options...
Riverton Studios Posted February 20, 2009 Author Share Posted February 20, 2009 I am sorry I made a new post. I assumed it was a different question. The other post was about the site's load time. I didn't discover the site search was slow until later.I have 800,000 products in the store. The site is still under development, so there will be more.I am not too technically savvy. How do I speed up my GET requests? Or is it because there are so many products?Thank you for your help thus far. Link to comment Share on other sites More sharing options...
Damien Metzger Posted February 20, 2009 Share Posted February 20, 2009 I'm only saying that the search isn't the cause of your trouble.A simple request on your website take 3 times longer than any other.I don't know if it's your sql server or the huge number of products (probably both).You need to analyse your db server statistics and see what takes so long.Disable statistics.Disable modules one by one and see which one have a real impact on your speed.Every pages does not need modules, disable them on the order process for example.You can do many things, but there's no miracle. Link to comment Share on other sites More sharing options...
Cronos Posted February 20, 2009 Share Posted February 20, 2009 I'm only saying that the search isn't the cause of your trouble.A simple request on your website take 3 times longer than any other.I don't know if it's your sql server or the huge number of products (probably both).You need to analyse your db server statistics and see what takes so long.Disable statistics.Disable modules one by one and see which one have a real impact on your speed.Every pages does not need modules, disable them on the order process for example.You can do many things, but there's no miracle. Hi Damien,Also there is a lot of scope in improvising Search.php in the Classes folder.The queries can be optimized even further for quick response times.Cheers..Cronos Link to comment Share on other sites More sharing options...
Riverton Studios Posted February 20, 2009 Author Share Posted February 20, 2009 What optimizations can be made to make it run faster? I have been playing around with removing modules and stats. I even removed every single module and that didn't affect it at all.If you know some fixes that can be helpful, please advise.Thank you. Link to comment Share on other sites More sharing options...
Cronos Posted February 20, 2009 Share Posted February 20, 2009 What optimizations can be made to make it run faster? I have been playing around with removing modules and stats. I even removed every single module and that didn't affect it at all.If you know some fixes that can be helpful, please advise.Thank you. Hi Riverton,Optimizations are within the SQL queries and SQL queries themselves.We need to optimize the code for better response times.Removing modules won't help dramatically, however, you can edit the Search.php in the classes folder to remove some search criteria, until an official fix for Search.php is released in future versions.I'm working on Search.php and will post any updates on this thread.Cheers..Cronos Link to comment Share on other sites More sharing options...
Riverton Studios Posted February 20, 2009 Author Share Posted February 20, 2009 That sounds great Cronos. I will do what I can in the meantime. Thank you. Link to comment Share on other sites More sharing options...
hammad008 Posted June 28, 2011 Share Posted June 28, 2011 Hey guys,I have implemented a new custom code to my prestashop and it works like a charm. The search works seamlessly and FAST.You may see it for yourself on the websiteshttp://www.freeposterz.comhttp://www.kobemarkdiamonds.comBoth websites have my code implemented and you can see it works great.I can help you guys, contact me on [email protected] and I will send you the code. Link to comment Share on other sites More sharing options...
Gipielle Posted July 8, 2011 Share Posted July 8, 2011 Can you post your solution here? So anyone can use it... Link to comment Share on other sites More sharing options...
Recommended Posts