mySql planning

[ggalan]

i see
im just worried that if i keep everything in a few tables then 1 table has a chance of ballooning to over 100K rows
btw, to clear up any confusion i am not trying to connect to different databases but rather thinking of dynamically creating new tables to keep the number of rows in a particular table under control, but djr33 suggested not to do this

[djr33]

It's better for organization to have more rows in a single table and fewer tables. Research "large databases" if you want. But you don't need to worry. I'm sure there are databases out there with millions of rows.

On the other hand, your server may not be powerful enough. But if the server is good enough then it should work. If you run into storage space issues or slow processing then it's time to move to a new server.


You can do whatever you'd like, but having lots of rows is a main design feature in databases.

[ggalan]

great! thanks for all your input

[traq]

the default max table size using the MyISAM engine in mysql is 4GB. Properly configured, you can increase that to 65,536 TB (yes, terabytes). it's more of an operating system (or plain old disk size) issue than anything you might need to do differently with your data structure.