Shopping Cart Operations > Tips and Tricks

Database Performance for a lot of Products

<< < (2/2)

jcschott:
Thanks guys, I wanted to update on what I have done so far as it doesn't appear to be an issue with the product table/ or database performance. I am still tracking down the issue on my end but abantecart appears to be handling the amount of products and categories just fine.

I tried to do some tracing and error capturing and I am going through that still. I did do a fresh install of abantecart and pointed that install to the existing database. Adding/Editing products was just fine and storefront was behaving as expected and copied all the resources over to the new store in case we had some heavy processing for some reason. I then made that fresh install my primary store by renaming the folders (My site's store is in /shop directory). Once renamed the now new install is having the same issue with spiking CPU upon editing products and the old install is not having the issue so I am leaning to some kind of local network routing issue or php path issue.

Basara:

--- Quote from: jcschott on December 29, 2024, 03:07:24 PM ---fresh install of abantecart and pointed that install to the existing database.

--- End quote ---
When installing to an existing database, please ensure you clean it up beforehand by dropping all tables. The CPU spike when editing a product may be related to the AbanteCart cache being removed and regenerated.

jcschott:
Yes I think it might be a cache issue if Abantecart attempts to clear the product cache after any type of product update I'll do some more digging as I am trying to avoid having to reimport all the data after dropping the tables. Interesting though it only is for one install and not the other using the same DB, same version just different folders on the host. Also running into mysql max users error during some peak CPU processing times (Currently set at the default 150 connections)

Freddieblakes:
Sounds like maybe the perpetrator is caching, especially since it only happens on one install. Maybe a config or permissions issue between directories? And reaching MySQL max users limit of 150 during CPU spikes might mean it's time to tweak the limit or keep an eye on long-running queries. Curious to know what you find!

Navigation

[0] Message Index

[*] Previous page