Re: How many rows does a table can hold?
I think a good soluthion it is to do a table for every thing and use MERGE table for searching data in all the table (for MERGE see documentation at pag. 271 "MySql table Type" chapter). Il 16:24, mercoled 14 marzo 2001, abdelhamid bettache scrisse: 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 . thank you sorry for my english __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.com - 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 - 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
RE: How many rows does a table can hold?
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
Re: How many rows does a table can hold?
On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote: I want to ask you : 1- How many rows does a mysql table can hold? Millions. Probably billions. I've heard of someone putting 2 billion rows in a table before (if memory serves). 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 . If the data structures are identical, there should be little need to split them out into their own tables. Speed shouldn't be an issue if it is indexed properly. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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