Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Estimating DB size

Quote Reply
Estimating DB size
 
I'm trying to determine whether we should use DBMan or DBMan SQL. The main difference, if I understand correctly, is that DBMan SQL is better at handling databases bigger than 1MB. So... how do I figure out if my database is going to be bigger or smaller than that? I am completely new to this so you can assume I have no background whatsoever.

Thanks in advance.

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/
Quote Reply
Re: Estimating DB size In reply to
thanks -- new to all this -- just discovered Search and did indeed see previous posts -- appreciate your help.