File Cache expected behavior

[jcschott]

I wanted to see if this is expected behavior or I have an issue on my local install. When editing a product and saving is it normal for the entire product cache folder deleted and have the product cache completely rebuilt instead of that individual cache file?

Also on checkout (order success) the product cache folder is completely deleted and rebuilt leading to a lot of CPU processing when editing or when a sale has gone through. Not sure if this is expected behavior with cache or an issue on my end.

I have also tried memcached and while I haven't ran it to fully debug the performance indicates it is dropping the entire cache instead of just the individual key to rebuild.

[abolabo]

I wanted to see if this is expected behavior or I have an issue on my local install. When editing a product and saving is it normal for the entire product cache folder deleted and have the product cache completely rebuilt instead of that individual cache file?

Also on checkout (order success) the product cache folder is completely deleted and rebuilt leading to a lot of CPU processing when editing or when a sale has gone through. Not sure if this is expected behavior with cache or an issue on my end.

I have also tried memcached and while I haven't ran it to fully debug the performance indicates it is dropping the entire cache instead of just the individual key to rebuild.

product stock affects on categories, brands information + related products list etc. That's why we deleting all cache of product section. There is cannot be "individual" file.
I really don't understand how CPU processing related to writing of usual text file.
May be it's a mysql server load.

[jcschott]

Yes the file creation isn't causing the cpu but something in rebuilding the cache. I found some inconsistancies in some of the data in the products table, inconsistant collation and some tables set as innodb instead of myisam. Just trying to pinpoint the bottleneck and expected behavior of abantecart and confirming it was normal to rebuild all the cache in the product folder every time a sale or edit occurred.

[Basara]

some tables set as innodb instead of myisam

Hello.
Some tables may be added through third-party extensions.