Load on site and database is high

Hey @wordpresschina. Thanks for reaching out.

You’re right that the database table size can grow a lot if you have a lot of traffic.

The easiest thing to do to clear out the table is to use the link on the help tab of the plugin to remove all carts from that table. This solution works, but isn’t the best because it literally clears all of the data.

I’ve also been playing around with the idea of adding a feature to add a setting to only keep carts for a certain number of days. Doing this would sort of self clean the table. Know what I mean?

Hey @wordpresschina

Your support request has me a bit worried because I want to be sure that the plugin doesn’t hurt site performance. In development/testing I’ve had thousands of carts in the table with no impact but that’s not real world data per se. Perhaps the data you have might help me find a way to improve things.

Any chance you still have the data from the table or know how many rows were in it? Were you seeing slowness only on the report page?

Thank you for your help. I deleted it a couple hours ago as well as the table. My entire wp_posts on that site is only about 150mb so this cart plugin grew to over 200mb in about 2 weeks and was very large on the site since it was installed. Since uninstall, timeouts on both the admin cart and frontend have dropped from around 4.5 to only 1.2 for server load. It was rising to 4.5 over past week steadily.

Yes would be good idea to prune automatically more often.

Alright no problem.

I’m going to play around some more locally with things and see if I can really ramp up the amount of data in that table. There may be a SQL index that would help with front end performance.

Since you’ve uninstalled would you mind if I close this request?

Yes you can close it and thank you for your assistance.

Marking as resolved.