Can the ecs_stats database table records be deleted? When backing up an ECSHOP database, you may find the database file is very large. Upon inspection, the ecs_stats table is often the culprit. This table stores access records, including spider and crawler visits, so it grows very large over time, making backups difficult or impossible.
In fact, this database table has limited utility. Modern third-party analytics systems are very powerful, making this built-in stats feature somewhat redundant. If you want to back up normally, you can choose to disable this stats feature. If you still want to use it, you can delete all records from ecs_stats before backing up. Here are two solutions for handling a large ecs_stats database table:
1. Disable it directly: Admin Panel — System Settings — Store Settings — Basic Settings — Site Visit Statistics: Off
2. Delete table records before backup: delete from ecs_stats