v1.6-v1.7 PrestaShop database cleaner module v1.0.1

Coolt

Active member
Elite
XNullUser
Joined
Dec 20, 2021
Messages
273
Reaction score
183
Points
43
NullCash
2,263

PrestaShop database cleaner module Clean up your db Speed up your site​

For a live site, the database will be bigger and bigger, because new data get added every day, like shopping carts, guests, logs, etc. Cleaning out old useless data to speed your site up.

The result: Faster website loading, better user experience and better SEO ranking.

Tables witch will be optimized: 3 statistic Tables

ps_connections
ps_connections_source
ps_guest

- The "connection" table is for the "Data mining for statistics" module, the module will add a new record to the table for every new connection to store data like when and who connects to your site. The table can be huge if your site has a lot of traffics. It's totally okay to clean it up.

- The "connections_source" table is also majorly used by the "Data mining for statistics" module, it stores data of where your site visitors come from, how people jump from one page to another, the table can also be huge. It's totally okay to clean it up.

- The "Data mining for statistics" module creates a record for every new visitors stored in the "guest" table to store information like browser type, screen resolution, operating system, language, etc. It's totally okay to clean it up.
Clean up

Various data new data will be added to your site every day, like shopping carts, guests, logs, connection data, etc, as time goes by, they will gradually reduce the performance of your database, slow your site down. This PrestaShop database cleaner module is designed to help you clean out old useless data from your site database to keep your site database be always in very good condition.

Why it's necessary to clean up the database.​

It's recommended for everyone to clean up your site database regularly. For a live site it's easy to reach 200,000+ logs, 500,000+ connections and 500,000+ guests, comparing with the amount of your product data, you would find that most of data in your database are useless, that's why you need to clean your site database up.

How come cleaning up the database reduces page loading time?​

Finding a certain row in a database is no much different with find a certain kid in a playground, the more children in the playground, the longer it takes to find the kid you are looking for, that's why cleaning up your database can speed your site up.
 

Attachments

  • stdbclear.zip
    6 KB · Views: 17

freiserk

Well-known member
Pro
Master
Diamond
Elite
Joined
Jan 24, 2019
Messages
3,455
Reaction score
6,444
Points
113
NullCash
35,180
Old version.

Latest:
  • V1.1.1
Do you have the latest version?

Thanks.
 

hegBIT

Well-known member
Master
Diamond
Elite
XNullUser
Joined
Mar 30, 2021
Messages
771
Reaction score
699
Points
93
NullCash
176
Good module
 

korque

Member
XNullUser
Joined
Jan 1, 2022
Messages
169
Reaction score
0
Points
16
NullCash
5
thanks
 

apllapll

Member
XNullUser
Joined
Apr 10, 2020
Messages
270
Reaction score
1
Points
18
NullCash
0
thx
 

ultimatone

Member
XNullUser
Joined
Apr 23, 2021
Messages
321
Reaction score
0
Points
16
NullCash
23
Cool! Waiting long time. May be not demo)
Post automatically merged:

Very sorry, not full version
Basic Prestashop database cleaner
 

wesmar

New member
XNullUser
Joined
Jun 30, 2021
Messages
2
Reaction score
0
Points
1
NullCash
10

PrestaShop database cleaner module Clean up your db Speed up your site​

For a live site, the database will be bigger and bigger, because new data get added every day, like shopping carts, guests, logs, etc. Cleaning out old useless data to speed your site up.

The result: Faster website loading, better user experience and better SEO ranking.

Tables witch will be optimized: 3 statistic Tables

ps_connections
ps_connections_source
ps_guest

- The "connection" table is for the "Data mining for statistics" module, the module will add a new record to the table for every new connection to store data like when and who connects to your site. The table can be huge if your site has a lot of traffics. It's totally okay to clean it up.

- The "connections_source" table is also majorly used by the "Data mining for statistics" module, it stores data of where your site visitors come from, how people jump from one page to another, the table can also be huge. It's totally okay to clean it up.

- The "Data mining for statistics" module creates a record for every new visitors stored in the "guest" table to store information like browser type, screen resolution, operating system, language, etc. It's totally okay to clean it up.
Clean up

Various data new data will be added to your site every day, like shopping carts, guests, logs, connection data, etc, as time goes by, they will gradually reduce the performance of your database, slow your site down. This PrestaShop database cleaner module is designed to help you clean out old useless data from your site database to keep your site database be always in very good condition.

Why it's necessary to clean up the database.​

It's recommended for everyone to clean up your site database regularly. For a live site it's easy to reach 200,000+ logs, 500,000+ connections and 500,000+ guests, comparing with the amount of your product data, you would find that most of data in your database are useless, that's why you need to clean your site database up.

How come cleaning up the database reduces page loading time?​

Finding a certain row in a database is no much different with find a certain kid in a playground, the more children in the playground, the longer it takes to find the kid you are looking for, that's why cleaning up your database can speed your site up.
THX, Where to put the new one for disarmament?
 

Sillumin

Well-known member
Pro
Master
Diamond
Elite
Joined
Jun 18, 2021
Messages
3,620
Reaction score
743
Points
113
NullCash
5,953
Thank you very much! It is very good module!
Post automatically merged:

Thank you very much! It is very good module!
 

jasiek

New member
XNullUser
Joined
Oct 20, 2021
Messages
25
Reaction score
0
Points
1
NullCash
4
Thank you very much! very good module It's very usefull.
 

unique

Well-known member
Diamond
Elite
XNullUser
Joined
Dec 12, 2020
Messages
1,775
Reaction score
406
Points
83
NullCash
578
where is link of demo?!!!
where is link of demo?!!!
 

scoopsat

Member
XNullUser
Joined
Nov 18, 2018
Messages
301
Reaction score
2
Points
18
NullCash
0
wow friend, thank you very very much for sharing
 

yerbap

Member
XNullUser
Joined
Nov 10, 2021
Messages
196
Reaction score
1
Points
18
NullCash
2
paylaşım için teşekkürler işe yarar..
 

jasiek

New member
XNullUser
Joined
Oct 20, 2021
Messages
25
Reaction score
0
Points
1
NullCash
4
Oops! We ran into some problems.
You have reached the amount of times you can react today. why am I getting this error a day later
 

EBerk89

New member
XNullUser
Joined
Sep 21, 2022
Messages
26
Reaction score
0
Points
1
NullCash
21
Oops! We ran into some problems.
You have reached the amount of times you can react today. why am I getting this error a day later
I don't know and i have the same problem
 
Top