> If he only has a few million records, why would this be more efficient?
Because MEDIUMINT takes up less space in the database. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Nick Arnett" <[EMAIL PROTECTED]> To: "Andrew Braithwaite" <[EMAIL PROTECTED]>; "'Ulterior'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, 01 June, 2003 10:47 Subject: RE: Insert query > -----Original Message----- > From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 31, 2003 12:05 PM > To: 'Ulterior'; [EMAIL PROTECTED] > Subject: RE: Insert query > > > Hi, > > I would use mediumint rather than int for the ID column (int has > support for > up to 2.1 Billion records wheras mediumint is up to 8.3 million - more > efficient for your data type). If he only has a few million records, why would this be more efficient? Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]