Cart Table has over 6 million rows
I've just downloaded a database dump of a client's website and noticed that it was taking an unusually long period of time, on closer inspection the
perch2_shop_cart table has over 6,600,000 rows inside. They all appear to be blank:
perch2_shop_cart_data table only contains around 900 records.
Is this something that is expected or does it suggest a problem somewhere with the checkout process?
Here is the diagnostics report:
Perch Runway: 2.8.34, PHP: 7.1.10-1+ubuntu16.04.1+deb.sury.org+1, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $, with PDO Server OS: Linux, fpm-fcgi Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), root_analytics (1.0.1), perch_forms (1.8.3), root_heartbeat (1.0.1), perch_shop_orders (1.0.12), perch_shop_products (1.0.12), perch_shop (1.0.12), perch_members (1.5), root_artithmetic (1), root_breadcrumbs (1.0), perch_mailchimp (3.0.1) App runtimes: <?php $apps_list = [ 'content', 'categories', 'perch_forms', 'perch_members', 'perch_shop', 'perch_mailchimp', 'root_breadcrumbs', 'root_arithmetic', ]; PERCH_LOGINPATH: /admin PERCH_PATH: /home/forge/madelittle.co.uk/build/admin PERCH_CORE: /home/forge/madelittle.co.uk/build/admin/core PERCH_RESFILEPATH: /home/forge/madelittle.co.uk/build/admin/resources Image manipulation: GD Imagick PHP limits: Max upload 32M, Max POST 32M, Memory: 512M, Total max file upload: 32M F1: 6a33f95eca3667f9e0c39bf5ca2980fe Resource folder writeable: Yes HTTP_HOST: madelittle.co.uk DOCUMENT_ROOT: /home/forge/madelittle.co.uk/build REQUEST_URI: /admin/core/settings/diagnostics/ SCRIPT_NAME: /admin/core/settings/diagnostics/index.php