[TYPO3-english] huge cache_data fields in table cache_pages caused by plugins / bad performace

[Stefan Frömken]

Hello Fabian,

I should try following:

Many pages make use of pdf generation. But while doing so it makes no 
sence to cache the generated pdf into database. I think the website user 
can still wait 5 secs instead of 2-3 secs. So try something like this:

pdf_generator = PAGE
pdf_generator.type = 123
pdf_generator.no_cache = 1

Don't activate no_cache = 1 for your normal page type!

Next step: enable useCachingFramework in INSTALL_TOOL and activate 
compression. This compresses cache_data entries. For more informations 
have a look into this page:

http://wiki.typo3.org/Caching_framework

If you're using CachingFramework you can also activate the 
garbageCollector within scheduler-extension to autoremove old entries 
every day (TYPO3 4.6.*).

Stefan


Am 07.07.2011 12:43, schrieb Fabian Schatz:
> Hi,
>
>
>
> the size of our cache_pages table is about 20GB. There are 150.00 entries.
> The field db field HTML is about 25kB per entry, the field cache_data about
> 200kB per entry. This is because every plugin on a page has a "configuration
> - string" of about 15kb (not the configuration of the plugin itself (this is
> very small), but other settings). We do have 10 to 15plugins per page (and a
> lot of pages).
>
>
>
> I think 20GB and more is not very good for the performance of the DB -
> Server and our Site. Is there any possibility of reducing the size of the
> cache_data field?
>
>
>
> Thanks a lot
>
>
>
> Fabian Schatz
>
>
>