Riverton Studios Posted February 12, 2009 Share Posted February 12, 2009 I have been putting together my site. I uploaded about 1/10th the amount of products that I need to, which is about 80,000. None of them (currently) have images.I have not edited anything. I have only added products. The site is soooo slow. Sometimes it doesn't even load at all. If you guys can see the website as normal, I would be very surprised.What can I do to make it faster? I have searched the entire forum. I have changed the force_compile to false and compile_check to false. This did nothing.I use Siteground as my host. As far as I know, they are one of the best. The site didn't function this slowly until I added the products.Here is the website: http://www.rivertonstudios.com/shopAny advice at all can help. I am not extremely technically savvy. Thank you in advance.P.S. If the category structure seems weird, that is because the site isn't finished. The structure will make sense when all of the products have been imported. Link to comment Share on other sites More sharing options...
spott Posted February 12, 2009 Share Posted February 12, 2009 To many MySQL request I think.First - what PrestaShop developers can say - You are not first person with the same problem with big products database.Secon - can You use some PHP cashe? Link to comment Share on other sites More sharing options...
Riverton Studios Posted February 12, 2009 Author Share Posted February 12, 2009 How do I reduce MySQL requests?First- I am only using about 600MB on my server. How can that possibly be classified as big?Second- How do I do this?I am a business owner, not a developer. I don't need specifics. I just need to be pointed in a general direction.Thank you. Link to comment Share on other sites More sharing options...
Riverton Studios Posted February 19, 2009 Author Share Posted February 19, 2009 I didn't make any modifications to the MySQL repquests or the cache, but when I removed the "New Products" and "Specials" modules the site runs much faster. I hope that helps people in the future. When you have as many products as I do, you customers don't care to see what the special is for one of them or to see which products are new.Thanks again. Link to comment Share on other sites More sharing options...
Ardian Yuli Setyanto Posted February 19, 2009 Share Posted February 19, 2009 thanks for the tip. Link to comment Share on other sites More sharing options...
Cédric Girard Posted February 19, 2009 Share Posted February 19, 2009 HelloThe problem isn't from MySQL access but simply the weight of the pages, because of combox with all your really numbered manufacturers :gulp: This combo hasn't any interest in SEO optimization neither for your visitors (so big !), erase this module from you Prestashop configuration ;-)(the weight of the HTML code - alone ! - is > 900 Ko !!!)Firebug addon (for Firefox) and its plugin YSlow is your friend... Link to comment Share on other sites More sharing options...
Riverton Studios Posted February 20, 2009 Author Share Posted February 20, 2009 Thank you very much for your help. I have removed the manufacturer's block, and yes that is much faster.Now 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?To test it just type in any band or artist. I have movies and music in the site.Thank you again.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...
Milaus Posted March 16, 2009 Share Posted March 16, 2009 i have the same problem,my site is to very slow please test for me "www.bimbisani.net"exscuseme for my english Link to comment Share on other sites More sharing options...
Cédric Girard Posted March 16, 2009 Share Posted March 16, 2009 Hello MilausI think it's your server which have a problem, because your homepage isn't really heavy. But the HTML page alone (34 Ko) takes +7 seconds to download (!)Other parts of the page (JS, CSS, images...) have normal timeout. Link to comment Share on other sites More sharing options...
arowana Posted June 3, 2009 Share Posted June 3, 2009 eventually i changed host and solve the problem Link to comment Share on other sites More sharing options...
Cédric Girard Posted June 4, 2009 Share Posted June 4, 2009 Great shop !Your site seems to load correctly on my computer ?... Not really fast, but enough faster to browse it as a normal consumer. Link to comment Share on other sites More sharing options...
arowana Posted June 4, 2009 Share Posted June 4, 2009 Thank You Cedric for browsing my site. It is fast at certain times like Mid-night US West Coast time (PST), but extremely slow during office hours. Sometimes it takes 2 mins to load one page... I wonder if there's any way I can speed up the site like other users who use prestashop ? Link to comment Share on other sites More sharing options...
troppelmann Posted August 1, 2009 Share Posted August 1, 2009 Hi,The problem occurs because the images you have, are stored directly in one folder. In fact the should be allocated in subfolders and more subfolders to prevent that server slows massivly down. there is yet no solution out of the box which solves this issue. But you can adapt major scripts which generates images upload images generate thumbnails ect. Then your pictures will be stored e.g. /p/category/reference/thickbox/3234342.jpg.This will massivly speed up the store and you don't have to wait till page is loaded within 2mins Best regardstroppelmann Link to comment Share on other sites More sharing options...
Recommended Posts