On Tue, 9 Apr 2002, David BORDAS wrote: > Sent: Tuesday, April 09, 2002 2:14 PM > Subject: Re: TIMESTAMP(14) or Bigint ?? > > TIMESTAMP is 4 Bytes and DATETIME is 8 Bytes. So, 4 Bytes difference > per 5 Millions records = a 20 MB bigger table ...
David If storage space is an issue you may want to use TIMESTAMP > But i think the feature "timestamp field of every row will > automatically be "timestamped" ... " will anoy me. You may assign explicit values to the timestamp column in INSERT and UPDATE commands. Thomas -- filter fodder: sql database --------------------------------------------------------------------- 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
