> > I've made some tests in the past, and the max. was about 2500
> inserted rows/second
>
> ...bummer
>
> > 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.
>
> was the commit after 10k inserts done for stability or performance?

performance and the commits need to be hard commits - NOT commit retaining
commits

>
> > The fastest solution seems to be external tables, though,
> > but it has limitations.
>
> what was the max for the external tables design?
>
> i speant the morning setting up and testing the parameterized insert
> query, and it doesnt seem to offer a significant enough performance
> gain. maybe a half seconf per 10k records, so either i'm doing this
> wrong or it just isnt significantly faster in my enviroment.

are you hard commiting these batches? - if not you will notice a significant
slowing exponentially as the batches move along.

>
> in which group is appropriate to post .net specific questions of this
> type?
>
> thank you
> gabe

the firebird dot net group is where Carlos may be able to suggest some dot
net solutions but a lot of this is server based and here is the best place
for that.
Alan