Phil,

> For each record imported there can be up to 75 'lookups'
> and/or insertions,
> and up to 50 calculations, all done in stored procedures.

I know this is a side point (to your major item - windows doesn't flush)
but humour me.

Have you profiled the performance of your import SP (indexes, etc) to
see if some optimization can be made?

As someone commented -- 25-30 hours to import 200Mb seems... excessive!

Personally, I would rather you really, really optimized the import
routine and always ran with Forced Writes = On (on windows) then depend
on closing the DB connection to prompt Windows to flush the pending disk
changes.

Also, a faster import process would yield benefits for your
linux/solaris installs!


Sean