I know Databases are supposed to be larger than the data normally would be in straight txt form, but 370% larger?
I'm a newbie to MySQL. I made a new database/table with 2 columns and I was importing a 24.1 meg TXT into column 2. It's nothing in particular...just radom txt and words because I want to see how SQL performs for myself. Configurations: Column1 = Primary Index, Not Null, Auto Number Integer(11) Column2 = Not Null, Unique (Which makes it indexed I believe) VarChar(45) When imported the data, the Table, the table size is now 89.5 meg. 24.1 meg to 89.5 meg seems extreme. Am I doing something wrong or is this really how it is? I'm thinking it might be related to the varchar column because it is misc txt. Thanks for any input.. Andrew --------------------------------------------------------------------- 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
