Re: 64bit insert delays

From: Paul Durrant (PaulDurrant_at_discussions.microsoft.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 08:27:01 -0800

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

  • [NEWS] Multiple Vulnerabilities in Oracle Database (Trigger, Extproc, Wrapped Procedures, PL/SQL Inj
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the Oracle database server. ... Oracle Trigger Abuse ... written in PL/SQL and execute with the privileges of the definer/owner. ...
    (Securiteam)
  • Re: Stored procedure/trigger and scripts
    ... must have been the trigger that locked up the table. ... SQL Server has permissions to execute xp_cmdshell. ... >> client to change their password they have to call the "Client Relations" ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored procedure/trigger and scripts
    ... I just ran some additional tests and it looks like my trigger is fine. ... SQL Server has permissions to execute xp_cmdshell. ... >> client to change their password they have to call the "Client Relations" ...
    (microsoft.public.sqlserver.programming)
  • Re: Best Practice - xp_cmdshell question
    ... execute from the trigger and use an alternate method. ... objects in an sa-owned database. ... >> without direct user execute permissions by changing your user database ...
    (microsoft.public.sqlserver.security)
  • Re: ICommandText.Execute on table with trigger returns wrong RowsAffected?
    ... Thank You for your replay Erland! ... That's what I have done - I'm using IMultipleResults and the last one (after ... all trigger statements are executed) is the one I need. ... But I'm trying to understand why Execute returns value of RowsAffected not ...
    (microsoft.public.data.oledb)