Problem with a lot of inserts in short time - SQL Server 2000

From: edi <edward.weinert@xxxxxxxxx>
Date: Tue, 26 Feb 2008 12:32:09 -0800 (PST)

Hi!

We have SQL Server 2000 on virtual machine (slowly). We run a pair of
stored procedures from ADO.NET 2.0 (WebService):
- first procedure: insert into table A a data row with correlationID
- next procedure: search for inserted record in tab A by
correlationID and insert value into tab B with constraint to tab A.

The problem is when we try to do this in short time (few minutes)
thousands times (5000/6000 pairs in 5/6 minutes) in 100 parallel
threads:

query in second procedure cannot find inserted record in first
procedure.

Everything is dirty read. no transactions.

Have you any ideas?

edi

.

Follow-Ups:
- Re: Problem with a lot of inserts in short time - SQL Server 2000
  - From: Erland Sommarskog

Prev by Date: Re: Help setting up stored procedure
Next by Date: Re: Syntax to access database on another server
Previous by thread: Help setting up stored procedure
Next by thread: Re: Problem with a lot of inserts in short time - SQL Server 2000
Index(es):
- Date
- Thread