> I want to ask you :
> 1- How many rows does a mysql table can hold?
> 2- I have to design a database for all universities of my country , Is it
> better to consider one database for each university or one database for
all
> universities . Note that a query on a table "student" would be more quick
> if I use for every university its own student table .
The Internet Football Club is a footy game by Rage which uses mysql as the
backend database. We run this on a Windows NT box and have found mysql good
for 3 million plus rows. However we still split the tables into a day-by-day
transaction basis so we won't exceed 3 million. This is a similar approach
to the idea of splitting the table into separate Universities.
We use php and apache with mysql.
gavin
http://www.internetfootballclub.com/ifc/game.htm.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php