On 24 Feb 2003, at 17:44, Julian wrote: > MEDIUMINT takes only 8 bytes, but BIGINT takes 20, so the whole DB > grows,
Where did you get those numbers? According to the documentation (http://www.mysql.com/doc/en/Storage_requirements.html), MEDIUMINT is 3 bytes and BIGINT is 8. And why are you going straight from MEDIUMINT to BIGINT? It seems that INT would work for you, since if you're inserting 10000 records per day it will take you more than 1000 years to reach the upper limit for an unsigned INT. You seem to be saying that your table will only have about 10000 rows, so I think you're worrying too much about the size of your index. Even if you use BIGINT, the keys would be contributing only 80K to the index size and 80K to the data size. But if you like you can make the index size smaller by using PACK_KEYS=1 when creating the table (assuming it's MyISAM): http://www.mysql.com/doc/en/Key_space.html [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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
