Re: 64bit insert delays

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 18:30:54 +0100

If you execute them in QA using the same QA window, then they are executed synchronously, i.e., the
second is waiting for the first to complete. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Durrant" <PaulDurrant@discussions.microsoft.com> wrote in message 
news:157B7278-E1B7-4A5D-BA95-D931C5C637CA@microsoft.com...
> all key fields are indexed
>
> and yes there is a trigger on this table, it does a select statement on
> another table to see if  the user exists in that table, and does an
> insert/update of the  other table depending on the results, but looking at
> the profiler it only takes 140 to execute this insert,
>
> if the two statements are executed in the query anylser, are these treated
> as one thread eg the return will not be  done untill each statement has
> completed
>
> if so then this is not the same as what we are seeing in that thread one is
> the insert and thread two is the select
>
>
>
>
> "Tibor Karaszi" wrote:
>
>> If that takes significant time, then you have some other problem. Your initial description 
>> suggests
>> that the data isn't there. But this information suggests that the process takes along time, so 
>> you
>> probably have some locking etc going on.
>>
>> Do you have any triggers on the emailsend table? That could explain the slowing down. Also, do 
>> you
>> have an index on the keyid column?
>>
>> -- 
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "Paul Durrant" <PaulDurrant@discussions.microsoft.com> wrote in message
>> news:4C89F5AD-90E5-4EFD-8CE9-27AE5E9D64B5@microsoft.com...
>> > insert into emailsend (emailfrom) values ('test@test.com')
>> > select * from emailsend where keyid = @@identity
>> >
>> > this took 1 min 22 sec to execute
>> >
>> > i have run the indexing wizzard against the running inserts and there was no
>> > recommended indexed need
>> >
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> Are you saying that you perform an INSERT and after that a SELECT and the SELECT doesn't show 
>> >> the
>> >> new data until after some 5 minutes? Can you reproduce this using SQL commands from Query
>> >> analyzer?
>> >>
>> >> -- 
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Paul Durrant" <PaulDurrant@discussions.microsoft.com> wrote in message
>> >> news:F3775D2F-1122-4118-AC49-342759B7A8C8@microsoft.com...
>> >> > we a system fed by various sources (foxpro,dotnet,ado) and we are seeing
>> >> > delays in the data being available, there are no insert errors, but the data
>> >> > does not appear for selection for at least 5 minutes
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

Relevant Pages