DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: database size

  1. #1
    Join Date
    Jun 2000
    Toronto, ON, Canada
    I have around 80 tables, two of them historical tables which are estimated to grow up to 4G/month. Beside that I have some BLOB fields containing pictures, so those tables can also grow a lot. No of concurent users is no more than 10.
    Overall, the database can grow up to 55 G.
    Is that database considered big?

  2. #2
    Join Date
    Nov 2000
    Big is a relative term. To me, 55G is very small. A couple of years ago, the term VLDB (very large database) was used with DBs of 100G or more. Today, I consider a 1TB database VLDB.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Yes :D
    I would recommend Partitioning.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  4. #4
    I recommend you store those BLOB columns in a separate tablespace, since they are probably stored out of line anyway (if they are over 4k).

    This will also allow for more space in the original table(s).

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.