> -----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]