MySql Limit???

[Anon]

1.How many Records MySql can create in MYSQL?....
2. How to create database MySql to speed
when I have many record...(more than 1 table to join)
Thnk you for all Answer..:-)

[Anon]

1. You can have as many records as you want. As you get more, it affects your speed of course, as with any database. The only limit is the total filesize imposed by your OS.

2. Look for some articles on database normalization. I can't remember any links right now, but that's what you're looking for.

---John Holmes...