RE: Maximum number of rows in the table

2002-05-07 Thread Peter Lovatt
--- > -Original Message- > From: Paul [mailto:[EMAIL PROTECTED]] > Sent: 07 May 2002 08:20 > To: Remco Oosten > Cc: [EMAIL PROTECTED] > Subject: Re: Maximum number of rows in the table > > > Our MySQL table currently has 2.5million rows, but

Re: Maximum number of rows in the table

2002-05-07 Thread webmaster
> I don't think there is a limit. > Just as long as your harddisk can contain the data there should be no > problem. Yes, I guess this should be the case. Theoretically, though; the limit would be the number of indexable rows, wouldn't it? Since the integer length used to store this is 11 digits,

Re: Maximum number of rows in the table

2002-05-07 Thread Paul
rows in the table I don't think there is a limit. Just as long as your harddisk can contain the data there should be no problem. Remco - Original Message - From: "chandra shekar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 5:21 AM

Re: Maximum number of rows in the table

2002-05-06 Thread Remco Oosten
I don't think there is a limit. Just as long as your harddisk can contain the data there should be no problem. Remco - Original Message - From: "chandra shekar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 5:21 AM Subject: Maximum

Maximum number of rows in the table

2002-05-06 Thread chandra shekar
Hi MySql gurus, We are using MySql for our database support in our project. It is a multiserver environment. We are using a single table to store info abt objects of each server. We want to know what is the maximum number of rows that the MySql supports for a table. In our case when the number of