Database Maintenance

[Guest]

Hi

 

I was wondering if anyone does, or should we do, database maintenance

 

What I mean is in the back office (fron office is fine - well we would like it faster but that will be another story), when I look at the orders tab, we have over 2000 orders paginated so we see 20 or 50 at a time

 

When I click the Orders tab, does the database get all 2000 orders?

 

The reason I ask is because on my ipad i am getting some serious delays where it will take 20-30 seconds to update the page, or switch to say the customers tab. I do not notice this on our second store which only has about 50 orders in total

 

So, as the orders / customers grow should we be deleting older orders for example to help keep things speedy?

 

OR

 

has the number of orders / customers got no effect at all on the speed of the back office?

 

I do delete unconverted shopping carts after a couple of days - is this good practice?

 

Help / advice / maintenance suggestions much appreciated

[shokinro]

I think the issue is not because you have more than 2000 orders, it should not cause the issue. Customers data records usually should be the same number as that of orders. I guess there is something else that caused the loading delay.

 

Anyway PrestaShop does not load whole 2000 orders, it only load number of records of page size that you specified.

[Guest]

Thanks for the reply. Our site is quite slow anyway, so I need to try and speed things up. Does have multiple languages installed slow things down? Each product has all their details 7 times in different languages. I assume this will be in the sql database? which is currently about 78 MB is that large? Will that slow down the site?

[shokinro]

when database become bigger and bigger, it will slow down the database access. if the whole site is slow down, then it also could be related to your server resources.

 

Do following things may help improve

- rebuild index (Preferences tab - Search tab)

- set to use smarty cache instead of "force compile (Preference tab - Performance tab)

- delete unnecessary data (ps_connections, ps_connections_page, ps_connections_source)

 

Please backup your site and database before make any changes just in case.

[Guest]

Thanks, I do rebuild he index regularly, and use smarty cache

 

I will have a look at deleting the data in those tables

 

I am also thinking about CDN but I can't find any easy to understand information about how to use it

[shokinro]

thanks for sharing, the url you post is wrong, you missed : after http

here is correct one and in English

http://catalogo-onlinersi.net/en/back-office-prestashop-modules/217-delete-connections.html

[Guest]

Check this free module: http://http://catalo...conexiones.html

 

Thanks

 

The link ddid not work it should be : http://catalogo-onlinersi.net/en/back-office-prestashop-modules/217-delete-connections.html