INSERT Delay
From: ewm (ewm_at_discussions.microsoft.com)
Date: 09/10/04
- Next message: Don Miller: "EXEC an SP Multiple Times with SELECT?"
- Previous message: Bill Gregg: "Do FK constraints also need Indexes?"
- Next in thread: Alejandro Mesa: "RE: INSERT Delay"
- Reply: Alejandro Mesa: "RE: INSERT Delay"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Sep 2004 11:39:02 -0700
Background Information:
I have a VB program using ADO that makes entries using INSERT in a SQL 2000
database. All entries are made in pairs. Each insert statement that is
generated includes the date and time the insert statement was created. The
two text strings are concatenate into one string with a CRLF (vbCrLf) in
between. The two strings are then sent to the server using connection.Execute
(InsertString). These INSERTS occur every 15 - 45 seconds.
Problem:
A few times a day the inserts are delayed, sometimes by as much as 30-40
minutes. In some cases the first INSERT is executed and the second one is not
executed for several minutes. When this happens, there are several other
INSERTS that are executed between the two sent as a batch. I know this is
happening because I get two records in the table with the same timestamp
(from the program not from SQL 2000) but they have IDENTITY value field
values that are 100 - 300 values apart indicating one INSERT in the batch was
executed, INSERTS for follow on batches are executed, and then the second
INSERT of the first batch is executed. This does not happen all the time. In
a given workday, about 2000 - 2400 entries are made. This problem occurs 0 -
10 times in any one day.
Any ideas what is going on?
Thanks in advance,
ewm
- Next message: Don Miller: "EXEC an SP Multiple Times with SELECT?"
- Previous message: Bill Gregg: "Do FK constraints also need Indexes?"
- Next in thread: Alejandro Mesa: "RE: INSERT Delay"
- Reply: Alejandro Mesa: "RE: INSERT Delay"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
