RE: How many rows does a table can hold?

2001-03-15 Thread gavin . wood
> 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 qui

Re: How many rows does a table can hold?

2001-03-15 Thread Rino Nucara
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

Re: How many rows does a table can hold?

2001-03-14 Thread Steve Ruby
"Jeremy D. Zawodny" wrote: > > On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote: > > 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

Re: How many rows does a table can hold?

2001-03-14 Thread Jeremy D. Zawodny
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 uni