Have you tried...

....setting the isolation level for all read operations to READ UNCOMMITTED ? That way it's not waiting for any transactions to commit and can help performance tremendously.

I mean, there's no reason to use any higher isolation level with the nature of this application.

Posted By: Steve in Holland, May 9, 15:56:27