I've made some tests in the past, and the max. was about 2500 inserted
rows/second
The database had Force Writes off and the insert parameters were
prepared. Also tha transaction was started programatic and with a
commit after 10k inserts.

The fastest solution seems to be external tables, though, but it has
limitations.

--- In firebird-support@yahoogroups.com, "pwidf" <pwidf@y...> wrote:
> i'm looking for direction in terms (i hope) of existing documentation
>
> if the dataset only contained a 100,000 records the time would be
> acceptable at about a second per 1000 records, but at a million or 2
> reconds this just takes too long. i'm hoping that there exists a
> solution that can insert the data into the firebird in close to the
> same time that it takes to get the data from the source databases.
> ex, a million or so records from the source databases takes about 3
> minutes.
>
> is it possible to select the data from the source databases directly
> into the firebird database?
>
> i'm using the 1.6.3 .net provider and the 1.5.2.4731 embedded
> firebird engine, and am not at all oposed to changing either if it
> will help.
>
> help with either of these questions is much appreciated.
> gabe