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

[Allan Jacobsen]

Which version of mysql are you using ?
Unless it is version 3.xx you have to explicitly disable caching.
Otherwise it will be used.


Best regards/MVH
Allan Jacobsen
Infrastruktur, Dansk Tipstjeneste A/S
Korsdalsvej 135, 2605 Brøndby

-----Oprindelig meddelelse-----
Fra: typo3-dev-bounces at lists.netfielders.de [mailto:typo3-dev-bounces at lists.netfielders.de] På vegne af Ernesto Baschny [cron IT]
Sendt: 29. marts 2006 09:37
Til: typo3-dev at lists.netfielders.de
Emne: Re: [TYPO3-dev] Typo3 Database design question (optimization /indices)

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
_______________________________________________
TYPO3-dev mailing list
TYPO3-dev at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev