dandumit Posted February 28, 2014 Share Posted February 28, 2014 (edited) HI, I run my site on Presta for several years now. some tables have reached a big dimension : Table Rows Size - ps_guest 1,116,292 105MiB - ps_connections 777,771 82.1MiB - ps_connections_page 1,967,463 81 MiB - ps_connections_source 148,182 67.9MiB - ps_product_lang 7,508 49.2MiB - ps_pagenotfound 470,376 46.7MiB - ps_specific_price 248,564 42.6MiB - ps_page_viewed 893,213 36.9MiB - ps_search_index 414,054 11.1MiB - ps_cart 33,645 5.4MiB - ps_cart_product 35,228 2.4MiB Only connections tables have together over 200MB. It's almost half of database. Is there any maintenance procedure in order to flush older data from those tables ? Until now site it's loading well. Hoever in BO when I try to access Carts it takes a while ... BR, Daniel Edited February 28, 2014 by dandumit (see edit history) Link to comment Share on other sites More sharing options...
jimmyc Posted June 18, 2014 Share Posted June 18, 2014 I am curious about this also. Link to comment Share on other sites More sharing options...
shacker Posted November 24, 2014 Share Posted November 24, 2014 I am curious about this also. use our free module delete connections to speed up the database Link to comment Share on other sites More sharing options...
Recommended Posts