how many rows can mysql database realistically hold?

[spewn]

i have a program that deals with 1000 entries a day...if i add 1000 entries each day into the database, at what point will it fill up and i have to create a new database?

thanks.

- g

 

[johnwm]

Depends on how much is each row, but 1000 items per day will take 30 years to reach 10 million rows, which isn't very big as a MySQL database. The limitation will probably be with your hardware

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints