max.record for mysql free edition?

[sysj]

Bagi rekan2 yg udah tahunan pake mysql free edition, berapa max.record yg dibatasinya? atau adakah efek terhadap data tsb, karna sy lagi buat prog.stock yg itemnya lumayan banyak?... makasih...

[rnd]

ini cuma contekan dari mysql 5.0
- Hadles large databases. We use MySLQ server with databases that contain 50 million records. We also know of users who use MySQL server with 60.000 tables and about 5.000.000.000 rows.

- Up to 64 index per table are allowed (32 before Mysql 4.1.2). Each index may consist of 1 to 60 columns or part of columns. The maximum index width is 1000bytes (767 for InnoDB); before the limit is 500 bytes. An index mau use prefix of a column for Char, Varchar, BLOB, or TEXT column types.

ini saya gunakan 5.0, masih ada versi diatasnya yg belum saya download, yang pasti, kalo cuma item sekelas hypermarket belum terlalu berasa

[davidmustakim]

Beda Enterprise Edition dan Community (Free) Edition boleh bilang hanya pada supportnya. Google, Yahoo, Adobe, Cisco pake MySQL ( http://www.forbes.com/technology/innovators/free_forbes/2004/0906/161_2.html ) Nah, mungkin perlu hati2 aja kalo nanti data stocknya udah dekat2 besaran datanya Google