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

[Ernesto Baschny [cron IT]]

Hi Allan,

Allan Jacobsen schrieb am 29.03.2006 09:42:

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

"query_cache" is not enabled by default in any MySQL installation I
know. Default seems to be "query_cache_size = 0":

http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html

"The default size is 0, so the query cache is disabled by default."

Cheers,
Ernesto


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


-- 
cron IT GmbH
Dipl.-Inf. Ernesto Baschny
Nobelstr. 15, D-70569 Stuttgart

Tel: +49 711 6868 909-33
Fax: +49 711 6868 909-10

Fingerprint: E918 7A64 9C50 CD35 67A9  752C 1C70 EE8B 915F 6438