I wanted to know if anyone knows what the “cscart_stat_requests” in tables is used for?
It has 424,292 rows in it.
It is the log of page accesses. I.e. tracks each user's navigation. When you “clear statistics” it will be truncated.
[quote name='tbirnseth' timestamp='1360860377' post='155290']
It is the log of page accesses. I.e. tracks each user's navigation. When you “clear statistics” it will be truncated.
[/quote]
Will it screw anything up if the “cscart_stat_requests” table is cleared?
why mess with the DB manually when there's a supported administrative interface to manage it? Never adjust the DB when an admin interface is available.
Have to agree with Tony here, there's no need to use the database directly unless there's exceptional circumstances. In this instance, the chances are that the cart uses data pulled from two or more cscart_stat_xxx tables to display statistics, so deleting one tables data will likely break something. Use the admin interface to clear statistics which will delete the data how it should be done.
Harpersmoto,
Just a thought, however, if I were having as many issues with site speed, and also in the process of searching for the best host, etc. etc, I would certainly be disabling the site statistics addon at least for the time being as it is only making things worse at this moment, you can always weigh the pros & cons of enabling this later! 