Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: Estimating DB size

Quote Reply
Re: Estimating DB size In reply to
Well, this has been discussed before in the DBMAN forums. You can do some simple calculations like the following:

1) Number of records (let's say 5,000)
2) Number of fields (let's say 25)
3) Number of bytes per field (let's say an average of 100 per field, some a lot less, some a lot more)

With this simple estimated calculations, you would have:

12 MGs of data

Now, this is just a simple example, but the average range of records with the default number of fields and configurations for DBMAN and Links 2.0 for that matter is between 3,000 and 5,000 records.

Anymore than that, than you will start seeing system degradation in terms of adding, editing, deleting, and searching data.

Hope this helps...

Regards,

Eliot Lee Wink
http://anthrotech.com/
Subject Author Views Date
Thread Estimating DB size Liza 2797 Jul 19, 2001, 1:05 PM
Thread Re: Estimating DB size
Stealth 2636 Jul 19, 2001, 1:48 PM
Post Re: Estimating DB size
Liza 2629 Jul 19, 2001, 3:05 PM