[Typo3-dev] Is Typo3 Robust ?

[Dmitry Dulepov]

Hi!

Martin Kutschker wrote:
> Dmitry Dulepov schrieb:
>>> mysql doesn't really care if a table has 2 or 10000 entries
> 
> Of course it doesn't. The speed of your application depends on the data
> you store and the queries you use.

Partially true, if you load a record through indexed ID, for example.
But in general searching disk file with 150000 record is not the same in
speed as for 2 records. Especially if you cannot create index OR mysql
refuses to use it even if you force index with "USE INDEX".

> Just curious, did you try to profile the queries? Sometimes rearranging
> the query helps.

Sure :) "EXPLAIN", fine-tune indexes, everything. I constantly work with
databases since 1997.

Dmitry.