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 17:13:46 +0100

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

  • Re: 64bit insert delays
    ... If you execute them in QA using the same QA window, then they are executed synchronously, i.e., the ... Tibor Karaszi, SQL Server MVP ... >> If that takes significant time, then you have some other problem. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: 64bit insert delays
    ... Tibor Karaszi, SQL Server MVP ... > we/users can query when mails were processed by the antispam system, ... this sounds like you are selecting from some other table than the one inserting into and you ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Truncating Log Files
    ... Tibor Karaszi, SQL Server MVP ... I have ran dbcc loginfoand used found that I have about 136 Gig at ... my LSN for Log Shipping and possibly break my Mirroring? ...
    (microsoft.public.sqlserver.server)
  • Re: Subquerie in CHECK Constrain
    ... I recall once retrieving a record set in VB, looping it and for each row, executing another ... Tibor Karaszi, SQL Server MVP ... >> Kalen Delaney ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: errr........getdate within a function.
    ... Tibor Karaszi, SQL Server MVP ... "Jacco Schalkwijk" wrote in message ... >> CREATE FUNCTION foo1RETURNS datetime AS ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
Loading