If you're going to do large bulk inserts like that, you should drop all indexes on the table, do the inserts and then recreate the indexes. SQL Server reindexes the table with every insert and this can cause the performance hit you mention.
HTH
>How can I speed up my inserting into SQL Server from VFP?
>
>I have tried creating and calling a remote stored procedure to do the insert but this goes the same speed as VFP inserting into a remote view. About one second per row. I have a test table of two and a half MILLION rows!!! The final version will need to insert between five and fifty thousand rows per day in a single transaction. I am fairly new to SQL Server (recently done the Implementation course). BTW, I am using 6.5 at the moment.
>
>Many thanks,
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
