<raptor@...> wrote in message
news:20020423164738.7ebabe4c.raptor@......

> hi,
>
> I will have the following scenario ..
> DB that will grow up to 10GB.

Ours is about 13GB

> Report generation (concurent users 1 - 5 maximum). (This I expect to be

heavy task, it should finish in maximum ~1hour from the start of the
generation)
Lots more users and a mix of daytime reports and overnight reports

> bulk inserts once a month ~400 000

Various, when we do a cheque run, it is about 100,000 a night. During the
day, we process the statements from the bank so I guess we have about
400,000 a month. Lots more users though.

>
> Any ideas, someone with similar setup.
> Does FB can handle easly this load on a powerfull computer ?

We are still running this on IB 5.6 on Dual processor Compaq's with RAID5
and about 40GB of disk space.

> What configuration u propose ?

We run on NT 4 SP latest.

> How long bulk insert takes.. do U have some measuraments ? (with indexes

off/on, autocommit off ofcource)
indexes on, forced writes on, single commit or multiple commits.

> whatever that come in your mind as recomendation ?

too many other variables to really give mush recomendation, other than load
test with 2x the data you expect! One day we walked in to find the win85
client couldn't cope with some of the tasks, if we had done the 2 x test, we
would have found the limits before going live.

>
> Question 2.
> Currently I think to do bulk-insert via Perl-DBI ? Data is transffered

from Oracle DB --> FB .. What do u think.
No experience of Perl.

> The report generation will be probably in Delphi ...
> Any idea how to connect to Oracle from Delphi (i haven't done that up to

now) ?
BDE or there are some dataset replacements for Delphi -> oracle.

> For the Delphi-FB-report-generation which Connection-technology u propose

! BDE !! the new Delphi6 ?
Probably won't matter a huge amount for reporting, depends if you are going
to need to chnage your reporting back end. BDE still works, although
considered by many a dead. For reporting I like ReportBuilder Pro, but
again, both of you Q's depend on what kind of reporting you are after.

>
>
> thanx in advance

No probs.

JAC.