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

[Dmitry Dulepov]

Hi!

Ernesto Baschny [cron IT] wrote:
> Do you have any statistics on what percentage of processing time is
> spend in the SQL-queries? If we are talking about <2%, then I would
> understand why noone has yet tried improving *that* part, since there
> are probably other "chunks" that are better candidates for optimizing.

It all depends on the traffic and how many of these "2%" are there in
the code. Typo3 does a lot of queries. If all of them run 2% faster and
you have 100 000 visitors, imagine how better it will be.

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

How many pages do you have? I have around 5000 on one site and I was
able to speed it up by adding indexes to the cache_pages.

> What about adding some compound indices, for example for "hidden,
> starttime, endtime, fe_group" fields? Those are almost always used
> together, it might speed up selection of records to be shown a bit.

Good idea but there is one bad thing... Mysql does not always use index.
We can add it but if it is too large in size, mysql will ignore it.

Dmitry.
-- 
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)