Results 1 to 5 of 5

Thread: look out for the size

  1. #1
    Join Date
    Jul 2008
    Posts
    65
    Thanks
    42
    Thanked 0 Times in 0 Posts

    Default look out for the size

    Hey, I was wondering if I have a database with 10,000 tables each have an average of 10 columns and 200 rows, each cell have about 5 characters, how much space will that take up? Thanks

  2. #2
    Join Date
    Jan 2008
    Posts
    4,168
    Thanks
    28
    Thanked 628 Times in 624 Posts
    Blog Entries
    1

    Default

    You'd have to check some way your self, it all depends on the data all of these hold. So we can't tell you right of the spot.
    Jeremy | jfein.net

  3. The Following User Says Thank You to Nile For This Useful Post:

    hosdank (08-12-2008)

  4. #3
    Join Date
    Jul 2008
    Posts
    65
    Thanks
    42
    Thanked 0 Times in 0 Posts

    Default

    Thanks ... Actually how would I check?

  5. #4
    Join Date
    Jan 2008
    Posts
    4,168
    Thanks
    28
    Thanked 628 Times in 624 Posts
    Blog Entries
    1

    Default

    I think that there would only be one way to do it... If you don't know what it is, then lol. Haha, not trying to be mean. I think you've gotta put it all in your self, or find out how much space each table, field, database individually it takes then multiply.
    Jeremy | jfein.net

  6. #5
    Join Date
    Sep 2007
    Location
    Maui
    Posts
    621
    Thanks
    274
    Thanked 14 Times in 14 Posts

    Default

    I doubt this will help you much, but I had a database that had 121,000 records (in all tables combined) and it was about 11Mb.

    I would shoot myself if I had to look after 10,000 tables haha. e

Bookmarks

Posting Permissions

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