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

["Marc Wöhlken [quadracom]"]

Ernesto Baschny [cron IT] schrieb:

> 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.

Regards
 Marc

-- 
...........................................................
Marc Wöhlken

Quadracom - Gottschall, Proffe & Wöhlken

Fedelhören 45a                 WWW: http://www.quadracom.de
D-28203 Bremen                E-Mail: woehlken at quadracom.de
______________             PGP-Key: http://pgp.quadracom.de