jimmyc Posted June 18, 2014 Share Posted June 18, 2014 (edited) Hi everyone. After experiencing some crashes and issues i have been on a search for the best ways to reduce the database and optimise prestashop. I am starting this thread for any contributors to comment and add recommend ways to optimize their sites. Possibly the most common thing i have found can be summarized by this post on an independent website. If you realized after running Prestashop for a long time, the database will get bloated because Prestashop track customer’s last visit and etc. If you can forgo these data, you will be able to compact the database and make Prestashop run faster. All you need to do is to empty the following three tables: ps_connections ps_connections_page ps_connections_source By emptying these tables, your database size will be greatly reduced. I would like to ask any prestashop pros out there if this is safe practice, after a database backup of course. AND if there are any measures we can take to help speed up the our prestashop stores. It would also be good to know what data we will lose by emptying these tables in myphp admin. Eg Will our monthly sales records and customers past orders be safe from discarding the massive build up of these tables. I have also noticed in some versions of 1.5 ps that using the "Auto-clean period" setting is not cleaning these tables. So, for some, backing up and updating sites can cause heavy loads and issues with these large tables present. Thanks for any assistance to anyone who can contribute to this thread and keeping prestashop stores running efficiently. . Edited June 18, 2014 by jimmyc (see edit history) Link to comment Share on other sites More sharing options...
fishordog Posted June 19, 2014 Share Posted June 19, 2014 i'm not a pro, but since i host website on shared server i had to do some things to speed it up. I disabled all stats related modules(i use awstats logs in cpanel to track stats) , cleaned all ps_connections,ps_connections, ps_connections_source, ps_guest(if you delete all these you will lose your stats). Also every few days i delete carts not associated with orders, which seems to help a lot. Two more things that were slowing down my site were Specials Block and Catalog Price Rules, so i disabled Specials module and don't use catalog price rules. Link to comment Share on other sites More sharing options...
BRPhotoroom Posted July 3, 2014 Share Posted July 3, 2014 I'd love to hear more about this aswell. I'm getting word from our webhost that "for every click, the computer must do over 100,000,000 operations on a database" Surely there is a way to tighten this up. Link to comment Share on other sites More sharing options...
El Patron Posted July 3, 2014 Share Posted July 3, 2014 I'd love to hear more about this aswell. I'm getting word from our webhost that "for every click, the computer must do over 100,000,000 operations on a database" Surely there is a way to tighten this up. that's what they say, to prove you can turn on profiling (note this turn it one for all visitors) config/defines.inc.php set to true define('_PS_DEBUG_PROFILING_', false); then test a page or multiple pages, this will show you what ps does. make sure to set to false when done. Link to comment Share on other sites More sharing options...
elfis Posted July 3, 2014 Share Posted July 3, 2014 (edited) I would like to known as well . Have two shops one on joomla+virtuemart and on prestashop. Virtuemart = 1200 product working fast - database size 18.7mb Prestashop = 190 product sometimes works fast - database 186.3mb I don't known why database is so huge. I turn off logs and clean old carts. ------------------------------------- Just install Vekia modul http://www.prestashop.com/forums/topic/275483-module-database-clean-up-optimize-store-db-speed-up-your-store/ hope will help. -------------------------------------- OMG Connection informations (337201) Connection informations (source) (107796) Guests (373408) unwanted carts (930) So works for me... database before 186.3mb now 46.3mb. Edited July 3, 2014 by elfis (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted July 3, 2014 Share Posted July 3, 2014 I would like to known as well . Have two shops one on joomla+virtuemart and on prestashop. Virtuemart = 1200 product working fast - database size 18.7mb Prestashop = 190 product sometimes works fast - database 186.3mb I don't known why database is so huge. I turn off logs and clean old carts. let us know what you discover Link to comment Share on other sites More sharing options...
elfis Posted July 3, 2014 Share Posted July 3, 2014 let us know what you discover Just install Vekia modul http://www.prestasho...-up-your-store/ hope will help. -------------------------------------- Remove: Connection informations (337201) Connection informations (source) (107796) Guests (373408) unwanted carts (930) So works for me... database before 186.3mb now 46.3mb. 1 Link to comment Share on other sites More sharing options...
El Patron Posted July 3, 2014 Share Posted July 3, 2014 Just install Vekia modul http://www.prestasho...-up-your-store/ hope will help. -------------------------------------- Remove: Connection informations (337201) Connection informations (source) (107796) Guests (373408) unwanted carts (930) So works for me... database before 186.3mb now 46.3mb. vekia is a rock star Link to comment Share on other sites More sharing options...
Recommended Posts