vekia 8,967 Posted September 17, 2013 Posted September 17, 2013 topic permanently closed please continue discussion in original module thread that is available here: https://www.prestashop.com/forums/topic/275483-module-database-clean-up-optimize-store-db-speed-up-your-store/ Database optimize module free module for optimizing database of your prestashop store. This free addon and decreases your website load time. How it works? PrestaShop stores a lot of unnecessary informations in database, this module allows to clean all unwanted informations, like abandoned carts, connections informations, guests informations etc. With this addon you can remove them easily. module works with prestashop 1.4.x - 1.5.x - 1.6.x - prestashop 1.7.x 4 Share this post Link to post Share on other sites
Jiten rash (away) 74 Posted September 17, 2013 Posted September 17, 2013 ok m gona test it 1 Share this post Link to post Share on other sites
vekia 8,967 Posted September 17, 2013 Posted September 17, 2013 thanks Jiten, please note that you will see the changes only in stores that exist a bit of the time (they usually have a lot of unnecessary data) but of course waiting for your suggestions Share this post Link to post Share on other sites
Jiten rash (away) 74 Posted September 17, 2013 Posted September 17, 2013 unitekhub is a bit slow so i installed there and cleaned things till now havent seen any changes hope it helps. manufacturer carousel module is responsible for its slowness ..the moment i disable it runs fast.. i need to edit things there. Share this post Link to post Share on other sites
vekia 8,967 Posted September 17, 2013 Posted September 17, 2013 maybe you've got some long waiting time to js files load? just wondering Share this post Link to post Share on other sites
Jiten rash (away) 74 Posted September 17, 2013 Posted September 17, 2013 (edited) No it wait for alomost 4.3 seconds to get connected every thing is fine. i am seeing some modules which creates ($Get) field from admin and not from its own makes site slow. note:its just a doubt by testing modules. and example med_contactable module it creates label for name email message from back end controller. Edited September 17, 2013 by Jiten rash (see edit history) Share this post Link to post Share on other sites
jolvil 79 Posted September 17, 2013 Posted September 17, 2013 A kind of similar module in spanish: http://www.prestashop.com/forums/topic/214923-modulo-prestashop-cleanner-ps15 Share this post Link to post Share on other sites
Dead2010 5 Posted September 18, 2013 Posted September 18, 2013 hello, my appears some things to clean up, it does not damage the site?leave attached image. Share this post Link to post Share on other sites
vekia 8,967 Posted September 18, 2013 Posted September 18, 2013 this module clean databases for: - guest informations - abandoned cart informations - statistics if you remove these datas, you will lost: statistics, abandoned cart if you are worries - you can always backup your database before clean Share this post Link to post Share on other sites
Dead2010 5 Posted September 18, 2013 Posted September 18, 2013 (edited) 'll test.I leave here the translation into Portuguese for your module, made in version 1.4.10 looks good, but it should not delete the statistics of how many visitors the site already has, neither carts delivered orders, etc.. greetings pt.php Edited September 18, 2013 by Speed2010 (see edit history) Share this post Link to post Share on other sites
vekia 8,967 Posted October 1, 2013 Posted October 1, 2013 thank you so much for your translation file. i will add it to 1.2 update. now i want to inform, that i updated this addon version 1.1 released Share this post Link to post Share on other sites
dosbiner 121 Posted October 6, 2013 Posted October 6, 2013 blank white page after install, I can't install to PS 1.5.5 Share this post Link to post Share on other sites
vekia 8,967 Posted October 7, 2013 Posted October 7, 2013 hello sounds strange because it is developed on ps 1.5.5 can you turn on error reporting and then you will se what and where doesnt work: open config/defines.inc.php find this line define('_PS_MODE_DEV_', false); change to look like this: define('_PS_MODE_DEV_', true); Share this post Link to post Share on other sites
joseangel2003 7 Posted October 15, 2013 Posted October 15, 2013 (edited) Nice! Edited October 15, 2013 by joseangel2003 (see edit history) Share this post Link to post Share on other sites
Jakaria Nawaz 1 Posted January 25, 2014 Posted January 25, 2014 nice one liked it. Share this post Link to post Share on other sites
TOMACALZATURE 1 Posted April 17, 2014 Posted April 17, 2014 nice one liked it. Database optimize module free module for optimizing database of your prestashop store. This free addon and decreases your website load time. How it works? PrestaShop stores a lot of unnecessary informations in database, this module allows to clean all unwanted informations, like abandoned carts, connections informations, guests informations etc. With this addon you can remove them easily. module works with prestashop 1.4.x - 1.5.x There is a version for prestashop 1.6 www.tomacalzature.com Share this post Link to post Share on other sites
vekia 8,967 Posted April 17, 2014 Posted April 17, 2014 you mean that you tested it on 1.6 and it worked? or you asking about 1.6 version ? Share this post Link to post Share on other sites
TOMACALZATURE 1 Posted April 17, 2014 Posted April 17, 2014 I can not seem to install it on 1.6 www.tomacalzature.com Share this post Link to post Share on other sites
marcocavicchioli 1 Posted May 12, 2014 Posted May 12, 2014 you mean that you tested it on 1.6 and it worked? or you asking about 1.6 version ? Is there a version for PS 1.6? tks Share this post Link to post Share on other sites
BoKr 28 Posted June 12, 2014 Posted June 12, 2014 Mh, something is stange here I can not install it in PS1562. Not via BO nor via FTP. It does not show in BO/modules. Share this post Link to post Share on other sites
chahidkhan 4 Posted July 7, 2014 Posted July 7, 2014 (edited) I tried to install it but i get blank page when uploading module , in local works fine but in my live website only blank page , other modules works fine .; any help ? My PS : 1.5.4.0 Thanks Edited July 7, 2014 by chahidkhan (see edit history) Share this post Link to post Share on other sites
Worldmart.in 4 Posted December 20, 2014 Posted December 20, 2014 Will it work with 1.6.0.8 MultiStore Set up Share this post Link to post Share on other sites
Antakarana 63 Posted December 25, 2014 Posted December 25, 2014 Hi Vekia, does it work with PS 1.6.0.9? thanks Share this post Link to post Share on other sites
Cyrius91 5 Posted January 13, 2015 Posted January 13, 2015 Hello Vekia, Thank you very much for this module. It's work fine in my ps1.4.9. Just I would like to know how I can keep the last ID_cart of database (or how I can replace by the last value after run your module) because I see that the Id_cart return to number 1 and when a guess add a article to the cart the database associate Id_cart with the old Id_order. Have you got a idea? Thank's again. Cyrille Share this post Link to post Share on other sites
Cyrius91 5 Posted January 21, 2015 Posted January 21, 2015 To solved this problem I need to find the last id_cart used in my backup mysql of PS (I added 10 of the number; for exemple [690 + 10=700])I opened my mysqladmin interface and open 'ps_cart' table. I run this sql request :ALTER TABLE `ps_cart` AUTO_INCREMENT =700Now the problem is solved. Share this post Link to post Share on other sites
vekia 8,967 Posted January 21, 2015 Posted January 21, 2015 hello may i know what module version you used? in newest i added feature to prevent situations like you had Share this post Link to post Share on other sites
Cyrius91 5 Posted January 21, 2015 Posted January 21, 2015 Hello Vekia, Yes of course, my module version is: Database Optimization v1.2 Thank's you very much for your answer Share this post Link to post Share on other sites
Cyrius91 5 Posted January 27, 2015 Posted January 27, 2015 Hello Vekia, Where I could fine the latest version of Database Optimization? Thank's in advance. Share this post Link to post Share on other sites
Cyrius91 5 Posted January 29, 2015 Posted January 29, 2015 Hello Vekia, I downloaded your latest Database Optimization and I see V1.1... I don't remember where I downloaded my version which is V1.2, do you know this version? Have a nice day. Share this post Link to post Share on other sites
vekia 8,967 Posted September 7, 2016 Posted September 7, 2016 topic permanently closed please continue discussion in original module thread that is available here: https://www.prestashop.com/forums/topic/275483-module-database-clean-up-optimize-store-db-speed-up-your-store/ new version of this free module is available! - added improvements to module configuration page - added feature to check updates directly from module configuration page - added new better support of prestashop 1.6.x - module works with prestashop 1.7 RC (release candidate version) Share this post Link to post Share on other sites
Recommended Posts