I think your best bet, then would be to grab the employee.gdb sample
database, add the schema up and check it against the empirical file size.
you might get close that way - and maybe check another one which is a lot
bigger.
Alan

-----Original Message-----
From: Infocare Developer [mailto:dev@...]
Sent: Wednesday, 12 February 2003 12:22 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] DB Sizing


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/
>
>



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/