MySQL Question!..

[Another]

Is there a limit to how many rows one MySQL table can contain.

I think i saw somewhere that there was a limit of like 2 million or 20 million. At the time i took no notice because i thought i would never need to worry...now i do need to know...eeeeek.

I had a quick look in the manual but couldnt find the information.

Any ideas, information gratefuly recieved!..

TIA

[gokhana]

from mysql manual:
------------------------------------------------------
Handles large databases. We are using MySQL with some databases that contain 50,000,000 records.
------------------------------------------------------
it does not say limit but i think limit might be around that too.

[lmergen]

hehe... ever tried to do a SELECT query on such a table? Especially with a WHERE clause? Man, you can be busy forever ... I already think it takes too long with 100k rows, imagine 50mil