puffdade Posted May 10, 2020 Share Posted May 10, 2020 My site is extremely busy I have fought hammer and nail to keep Presta running with the help of a few of the stars of this forum, now I have a question to help keep things going moving forward Im still using 1.6.0.14 it has plenty of bandaids, sticky tape and bandages holding it all together but works there are workarounds for most problems i come across even if sometimes unorthodox but I have reached a milestone of 1/4 of a million sales things are starting to slow up on the back office simple tasks like changing order status's can be tedious sometimes timing out completely I run off a dedicated server with reasonably fast specs on SSD drives, Im starting to wonder if the storage of all this data generated by prestashop is starting to get bloated and causing my problems Is there anything I can do to assist in getting my back office speed back up to normal and cut out the time outs its so frustrating mass marking orders for status change having it dump on me and of course time consuming. I don't want to upgrade to 1.7 for fear of it going wrong my experience's so far on upgrading are not good Thanks for looking Paul Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2020 Share Posted May 10, 2020 Optimization and cleaning is not a matter of one click, but a lengthy process for professionals. It is not possible to advise specifically. Personally, I see it approx. for two hours of work. Using any modules to optimize is suicide. Link to comment Share on other sites More sharing options...
puffdade Posted May 10, 2020 Author Share Posted May 10, 2020 This is some of the data that may be bloating my install Abandoned carts: 43,956 Connection stats: 25,760,842 Search stats: 436,464 Email logs: 14,618 Logs: 223,509 Guests with no addresses: 2 Customers with no addresses: 199 Guests with no orders: 757 Customers with no orders: 1,240 Expired specific prices: 140 Expired vouchers: 41 Unused feature values: 25 Empty features: 6 Thats got to put some strain on the system Link to comment Share on other sites More sharing options...
tomerg3 Posted May 10, 2020 Share Posted May 10, 2020 Whatever you do, do not mess with a working live site, it's never worth the risk. I would highly recommend you create a copy of your website (also known as a test site), and do all your testing/tweaking on it (as you do not want to mess with a live site that has sales). There are always things you can do to optimize, like checking / repairing the database, deleting / backing up old data from 1+ years back. You would do the same process if you wanted to upgrade to PS 1.7 (Install PS 1.7, and migrate your data to it from the working live shop, and only after the 1.7 is fully tested, migrate again and switch the shops). You can find a module to create a test site, and to migrate to PS 1.7 on our website. 1 Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2020 Share Posted May 10, 2020 (edited) Yes, the user @tomerg3 is right. That is why I wrote that it is necessary to leave the work to experts. Without knowledge of Prestashop versions, database structures (different for versions 1.6 and 1.7), etc. it will not work. You'll do it yourself for a week and eventually find out that you didn't succeed. Imagine that the backup of your database will not work, because it will be large, you have a lot of stored and unnecessary data. Likewise, restoring from a backup will not work. Advise you on what and where to do is to release a series of 1000 comments. Edited May 10, 2020 by Guest (see edit history) Link to comment Share on other sites More sharing options...
puffdade Posted May 16, 2020 Author Share Posted May 16, 2020 Thanks for the advice guys I have made a few minor tweaks removed all the historic abandoned carts removed all the fake accounts or accounts that look fake (no address or orders ) and things have improved immensely, Im not brave enough to do much else, I may however employ a database expert to carry out some cleaning and optimising tasks as thats a way out of my pay grade. Link to comment Share on other sites More sharing options...
El Patron Posted May 17, 2020 Share Posted May 17, 2020 wow that was long ago we upgraded your shop....getting long in tooth but serving you well, your welcome lol....not sure why we broke up so many clients come and go... we are putting clients on dedicated with NVME to ssd...our linux admin then tunes the mysql configuation....this will add 2-3 years to shelf life https://www.fasthosts.co.uk/dedicated-servers either silver or gold works note: legacy hosting still charges 200usd/gbp for nvme...ovh has also offer.....but both fast/ovh are less than what everyone else is charging just for the nvme run don't walk and get nvme. happy selling Fred Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now