Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2005
    Posts
    395

    Most space efficient DB

    I have a MySQL database which is about a GB so far, and is growing rapidly. Is there a DB, or anything I can do to the MySQL database as far as formatting, to conserve more space. CPU really isn't an issue, so even if a method to save space requires more CPU, its not a problem. I noticed when creating tables, there are options like MyISAM, InnoDB, MEMORY, HEAP, etc; do any of these take up less space than others?

  2. #2
    Join Date
    Dec 2005
    Posts
    395
    I did some research and found that the ARCHIVE format is best for space conservation, but my inputs are just characters ranging from 8-32 characters (CHAR and VARCHAR formats) without spaces, and would compressing really do anything for this format of data?

  3. #3
    Join Date
    Feb 2004
    Posts
    634
    The latest version of DB2 (version 9.1, nicknamed "Viper") probably is the most space efficient relational DB; it supposedly has very sophisticated row level compression features that can compress tables by 45-75%.

    For MySQL the default table type is MyISAM unless you specify otherwise, and it's the most compact disk-based storage engine. There is a separate utility available for doing column level compression on MyISAM tables called myisampack. There a lot of caveats with using it however (such as compressed tables becoming read only and restrictions on compressable data types), so I suggest you do some research on it. The use cases for it are pretty limited.

  4. #4
    Join Date
    Aug 2006
    Posts
    60

    compress the files

    may be you can perform this doing the zipping the files after some backup or else what is ur process!

  5. #5
    Join Date
    Jul 2003
    Posts
    277
    Just double check all the colum types, make sure you're not allocating extra space you dont need.
    Perl
    Java
    SQL

  6. #6
    Join Date
    Dec 2005
    Posts
    395
    I tried compressing the data using gzcompress() before storing, but the data didnt uncompress. I am looking into DB2 now. Thanks for the responses everyone!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •