>I will have the following scenario ..
>DB that will grow up to 10GB.
>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) bulk inserts once a month ~400 000
>Any ideas, someone with similar setup.

No, our setup isn't quite similar - just a couple of databases of 1Gb.
Exactly what should be reported within one hour? Hopefully not printing 400
000 pages of information...

>Does FB can handle easly this load on a powerfull computer?

Sure, I think the biggest IB database is close to 1Tb (1000 Gb)

>How long bulk insert takes.. do U have some measuraments ? (with
>indexes off/on, autocommit off ofcource)

Well, you don't say how big each record is, but it shouldn't take very
long. Probably a few minutes. As for indexes, just make sure they have high
selectivity and try turning them off if things go too slow (but I doubt you
will have any trouble).

>Question 2.

(removed those parts I know nothing about)

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

! BDE

>!! the new Delphi6 ?

I'd recommend IBO with FastReport. Haven't used FastReport myself, but have
heard positive things about it. And IBO is a brilliant tool winning the
Delphi Informants Best Database Connectivity Award every year. I think
ReportBuilder is the best alternative to FastReport.

HTH,
Set