[TYPO3-english] SQL - tx_realurl_urlencodecache TOO BIG

[Christian Reiter]

Hi,

How do you decide the table is "too big"?

Example: A TYPO3 site with 6395 pages, 3748 language overlays, 2624 
ttnews records currently has 575729 entries in tx_realurl_urlencodecache 
with 238 MB size. That's not so far from your 350 MB.

80% of the tx_realurl_urlencodecache entries are for tt_news, because 
this extension creates so many links with different parameters (archive, 
year, blabla)

Querying the table is still fast.

If the table is causing problems you might want to check whether you 
have some extension that is causing an unnecessary amount of entries.

Best regards,
Christian


Am 01.04.2014 21:56, schrieb Salander: > Hello,
 >
 > I have a little problem on my boss website, I saw on PHPmyadmin that his
 > table "tx_realurl_urlencodecache" grows
 > too much (350MB).
 > I think it's the robots of google who are creating these false datas.
 >
 > Is there a way to filter it? Are we forced to use
 > tx_realurl_urlencodecache? Can I desactivate this "cache"?
 >
 > Thank you!
 >
 > Salander


Am 01.04.2014 21:56, schrieb Salander:
> Hello,
>
> I have a little problem on my boss website, I saw on PHPmyadmin that his
> table "tx_realurl_urlencodecache" grows
> too much (350MB).
> I think it's the robots of google who are creating these false datas.
>
> Is there a way to filter it? Are we forced to use
> tx_realurl_urlencodecache? Can I desactivate this "cache"?
>
> Thank you!
>
> Salander