[TYPO3-dev] index on cache_hash ident field

[Rupert Germann]

Krystian Szymukowicz schrieb:
> I would not call myself and database expert so I'd like to ask you:
> should not there be an index created on filed "ident" in table 
> "cache_hash" ?
> 
> Typical use of ident in cache hash would be
> SELECT * FROM cache_hash WHERE ident = 'foobar'
> DELETE FROM cache_hash WHERE ident = 'foobar'
> 
> so the index on 'ident' would play his part quite well here, I think.
> 
> 
> With hundred thousands records simple "DELETE FROM cache_hash WHERE 
> ident = 'foobar'" create quite huge time lag (about minute).
> 
> What's your opinion?

in theory there should be an index, but practical this field is not used 
in the core - only by some extensions (e.g. automaketemplate).
but AFAIK there's no select query on this field.
So I see no problem here.

greets
rupert





-- 

Rupert Germann
tt_news maintainer, TYPO3 core developer, http://rgdata.de