[TYPO3] Problem with caches

[Bill Taroli]

Fred wrote:
> Hello,
> I have a serious problem with my cache on my Typo3 websites.
> Last monday I discovered that my database was about 90mo, after I cleard 
> all caches it was about 20mo.
> I checked and quite all the pages are set with "cache = 5mn".
> I tried to set this on my main template :
> config.cache_period = 180
> config.cache_clearAtMidnight = 1
> And this on the TS of the root page : TCEMAIN.clearCacheCmd = all
> But it didn't seemed to work.
>
> Does anyone has an idea of how to prevent this or how to empty those 
> cache automatically ?
>   

Comparing the size of the content mgmt tables and the size of the 
rendered output (which is what goes in the cache) can be an 
apple-to-oranges comparison, depending on the content that is being 
rendered. But if the DB size is a concern, there is another option. In 
my case, for example, my hosting company has a limit of 100MB for MySQL 
databases -- seems arbitrary, I know. So to protect myself from 
exceeding the limit due to the cache, I have set the following in my 
localconfig.php:

$TYPO3_CONF_VARS['FE']['pageCacheToExternalFiles'] = 'TRUE';

This way I make use of my 250GB web disk space allotment for the cache 
instead. ;-) YMMV

Regards,

Bill