Subject Re: [ib-support] DB Sizing
Author Infocare Developer
The overhead / Tare would be a start and I would appreciate that.

I was hoping there would be a formula that would say something like average
record size (for varchars etc) * #records + (#records * #indexes * index
size) + (arbitrary constant for file handling)
I know Oracle and Informix have ball park figure calcs like this that come
out to page sizes.

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, February 11, 2003 2:39 PM
Subject: RE: [ib-support] DB Sizing


> I think you might be able to calculate a "dry" (or tare) size, but this
> wouldn't help you much. It would all depend on how much traffic the
database
> were to receive. e.g. if you did a datapump style update to all records in
> one hit - it would double (roughly) the size of the gdb file since you
would
> retain the previous version of records.
> Not a very satisfying thing to attempt
> Alan
>
> -----Original Message-----
> From: Infocare Developer [mailto:dev@...]
> Sent: Tuesday, 11 February 2003 11:28 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] DB Sizing
>
>
> Is there a way to quickly calculate the approximate disk space a db would
> require given a schema and # Transactions expected?
>
> Thanx
> Russell
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>