optimalizace Mysql

[Kotala Zdeněk]

> informace zde. A tak jsem se dostal na 40K tabulek...nejmene 
> pracne by pro
> me bylo sloucit data do jedne tabulky a pracovat s ni.

To rozhodne udelejte! Protoze co se tyce ext2 tak jak pravy dokumentace:

There is an upper limit of 32768 subdirectories in a single directory.

There is a "soft" upper limit of about 10-15k files in a single directory
with the current linear linked-list directory implementation.  This limit
stems from performance problems when creating and deleting (and also
finding) files in such large directories.  Using a hashed directory index
(under development) allows 100k-1M+ files in a single directory without
performance problems (although RAM size becomes an issue at this point).


Coz znamena, ze pocet souboru v adresari muze byt vetsi nez 15k, ale
jelikoz pristup je linearni tak se to nedoporucuje.
V budocich verzich jadra se pocita s ruznymi algoritmy pro rychly pristup
(hash, stromy ...).

Jinak skutecny limit je 130 trilionu souboru. (ale nejsem si jisty jestli
je to trilion nebo bilion, ale i tak je to hodne).

			S pozdravem Zdenek Kotala