[TYPO3-dev] Typo3 Database design question (optimization / indices)

[Ernesto Baschny [cron IT]]

Marc Wöhlken [quadracom] schrieb am 28.03.2006 21:45:

>> In my tests, I see no difference in the "parse-time" (shown by TYPO3 at
>> the bottom of the page, if debug is on) when calling some typo3-page
>> with and without those indexes with "&no_cache=1".

> Do you have mysql query cache enabled? How much memory do you use for
> caching?
> 
> As you cant't measure any differences it may be the way that you have a
> relatively small Typo3 site and a large query cache. In this case most
> querys would come from cache and be delivered in virtually no time.
> 
> In situations like this your Typo3 site would not really benefit from
> indexes.

True, the site I tested is not very big. But I have no query-cache enabled.

Cheers,
Ernesto