On 8 Apr 2002, at 20:20, Roger Baklund wrote: > The best type to use is the one big enough to hold your expected biggest > value, but not bigger.
But when calculating your expected biggest value, keep in mind that the autoincrement counter increases on every attempted insert, even if the insert fails. That may or may not be significant, depending on what indexes your table has and how you do your inserts. [Filter fodder: SQL, query] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php