sqlite caching - speed, size of cache.db, when to delete it


After 6 months of using the “files” method of caching I am now trying the “sqlite” method. The website seems to load a bit faster using sqlite, so I think I will stick with it for the moment.

I have a few questions though - should I delete the cache.db file when it reaches a certain size? What would this size be (100MB, 500MB, 1GB)?

Is it OK to delete it daily - or would this cancel the benefits of using the cache system?

I have ~3,000 products (some products even have 5-6 product options) and … a lot of filters. Most subcategories have 2-4 filters.

Thank you in advance.

If it ain't broke, don't fix it.

[quote name='tbirnseth' timestamp='1318188372' post='123271']

If it ain't broke, don't fix it.


Yeah, that's how I think it is best - but the files cache wrote ~10k of files on the disk and I had errors, my some of the new filters did not display. This is the reason I chose sqlite.