hammad008 Posted April 4, 2011 Share Posted April 4, 2011 Hello I have created a website using Prestashop (www.freeposterz.com). Basically everything was going well before I flooded it with 550k posters on it. The search is super slow and most of the times I get a 500 internal server error (search Justin Bieber for example). I bought a dedicated MySQL VPS server for this to solve but still it doesn't work.Can you please tell me how can I fix this ?Thanks in advance,Hammad Link to comment Share on other sites More sharing options...
alirm Posted May 18, 2011 Share Posted May 18, 2011 Hi guys..I have the same problem with my website. I got an error most time when I want to browse and open links in my web pages.I think I know why my website is slow ( Using shared hosting) but I can not figure out why I have a Internal server Error??I would appreciate it if someone help to fix this problem??hammad008: I am really appreciate it if you found the answer and let me know your solution!!Thank you Link to comment Share on other sites More sharing options...
biglama Posted June 19, 2011 Share Posted June 19, 2011 Yep, thats because of too many items in DB and the search queary is badly implement and thats because this take so long, so you have to rewrite search query, iam finding solution just right now. Link to comment Share on other sites More sharing options...
hammad008 Posted June 28, 2011 Author 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...
alirm Posted June 28, 2011 Share Posted June 28, 2011 Thank you biglama and hammad008 for you response.Now, I found why my template works too slowly.Hammad008 I have checked your links and it seems works perfect.I will send you an email soon and hopefully get some tips from you since I am not highly expert to fix this problem.Again thank you guys and have a good one Link to comment Share on other sites More sharing options...
biglama Posted June 28, 2011 Share Posted June 28, 2011 its solved (without ajax search) here http://www.prestashop.com/forums/viewthread/52933/P45/#472149 Link to comment Share on other sites More sharing options...
Recommended Posts