Thanx, it will have to be a mission after all :-( Database has about 400
tables plus indexes etc

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


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