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

Reply via email to