Re: writing to database slows down

[John Payne]

With 400,000 records it sounds like you are doing a bulk dataload- doing it on the server gets rid of the network overhead, but you are absolutely right it defeats the purpose of client/server !

Dropping indexes speads up inserts on the server as the server justs needs to insert records and not maintain indexes, but at the cost of having little referenetial integrity, handy for bulk inserts !

Its sounds like it is the client rather then the server, but this depends on row size. If the network usage is low then this suggests that the client is not sending the inserts fast enough. Keeping connections open in code might help -saves closing and opening connections - connection pooling can help with this, using stored procedures to do the inserts increases write speed.