Jump to content
vekia

[module] Free database optimize addon - clean up db - speed up your store

Recommended Posts

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

 

database-optimisation-prestashop.png

  • Like 4

Share this post


Link to post
Share on other sites

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

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

maybe you've got some long waiting time to js files load? just wondering ;)

Share this post


Link to post
Share on other sites

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 by Jiten rash (see edit history)

Share this post


Link to post
Share on other sites

hello, my appears some things to clean up, it does not damage the site?
leave attached image.

post-512733-0-21785200-1379493012_thumb.jpg

Share this post


Link to post
Share on other sites

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

'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 by Speed2010 (see edit history)

Share this post


Link to post
Share on other sites

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

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

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

 

database-optimisation-prestashop.png

 

There is a version for prestashop 1.6

 

 

www.tomacalzature.com

Share this post


Link to post
Share on other sites

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

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

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 by chahidkhan (see edit history)

Share this post


Link to post
Share on other sites

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

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 =700

Now the problem is solved.

Share this post


Link to post
Share on other sites

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

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

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

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

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
Guest
This topic is now closed to further replies.

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More