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

Thread: database size

  1. 01-09-2001, 01:00 PM #1
    Mara
    Mara is offline Junior Member
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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?
    Thanx
    Reply With Quote Reply With Quote
  2. 01-09-2001, 03:15 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    Reply With Quote Reply With Quote
  3. 01-09-2001, 03:16 PM #3
    rcaballe
    rcaballe is offline Member
    Join Date
    Oct 2000
    Posts
    235
    Yes :D
    I would recommend Partitioning.
    Ramon Caballero, DBA, rcaballe@yahoo.com
    Reply With Quote Reply With Quote
  4. 01-09-2001, 03:24 PM #4
    bberg@rtnyc.com
    bberg@rtnyc.com is offline Member
    Join Date
    Jul 2000
    Posts
    105
    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).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width