Re: Data insertion too too slow...

On Nov 28, 10:30 am, Manfred Sorg <manfred.s...@xxxxxxxxxxxxxx> wrote:
On 28 Nov., 01:12, Don Li <tatata9...@xxxxxxxxx> wrote:

rows took about 7000ms. And I even added index hint. It's odd though
yesterday and the day before yesterday, the same query ran at least
100% faster.

The question is: What has happened?
Did anyone create a trigger onto your table?
That's a good guess if inserted takes suddenly much longer.

Bye, Manfred

That's a good question. As I recall the first few times when I ran
queries, they were not too slow (about 2 days ago) otherwise I would
have my "teeth" on them... theoritically no one other than me has
access to the machine, some hacker did nasty thing on my box?
possible but less likely, what's his/her motivation?

Thanks.





.

Relevant Pages

  • Re: Great SWT Program
    ... There's simply a dictionary definition of "frequent", ... None of the nasty things that you have said or implied about me are at ... You said you have a search query you're editing. ... Then it's not a multi-line query field. ...
    (comp.lang.java.programmer)
  • Re: getting data in triggers
    ... transaction will hold everything in lock until your trigger is done. ... Looking at your vbscript, you are making a new sqlconnection and attempting ... suggest you create a sql job and schedule it to run these external calls at ... >>> I can execute the script using xp_CmdShell in the SQL Query Analyzer ...
    (microsoft.public.sqlserver.programming)
  • Re: Please help me optimise this stored procedure.
    ... But do you really need this query? ... I assume your query is run in a trigger. ... UPDATE Titles ... Also, I forgot that the counters are in another table, not ...
    (microsoft.public.sqlserver.programming)
  • Re: Great SWT Program
    ... None of the nasty things that you have said or implied about me are at ... I thought you were editing the query text at that point. ... backspace deleting the next character to the left would be ... So you type the query, then hit something else, and the query becomes ...
    (comp.lang.java.programmer)
  • Re: date question
    ... that being said we have to agree that not all techniques are for all ... I haven't experienced such horrible benchmarks using the DATEDIFF functions. ... whether or not the trigger does any work, it is still a trigger and there ... query you just have to make the change to the code). ...
    (microsoft.public.sqlserver.programming)