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

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

in which group is appropriate to post .net specific questions of this
type?

thank you
gabe