|
Posted by Simon Hayes on 10/01/52 11:19
"Magnus Φsterberg" <magnus.osterberg@abo.fi> wrote in message
news:d9bgug$rcr$1@plaza.suomi.net...
> Hi!
>
> I'm experiencing the following experience problem with my SQL Server 2000.
>
> Explanation a' la example;
>
> 1.
> I insert data using my SP; EXEC dbo.up_DataInsert
> This is fine, SQL Profiler duration only a few ms.
>
> 2.
> I try to select the data.
> select * from dbo.tblData where DataNumber = 283279
> This is fine, SQL Profiler duration only a few ms.
>
> 3.
> delete from dbo.tblData where DataNumber = 283279
> This is NOT fine, SQL Profiler duration up to 50 seconds!!!
>
> I have got a unique index with ignore duplicate key and the table has
> about 180.000 records.
>
> What could be wrong here??
>
> /Magnus
>
>
>
No idea - have you checked the query plan in Profiler to see where the time
is going? And are there any other factors, such as a DELETE trigger on the
table? If you can post the table DDL (including keys and indexes) and also
details of the query plan (SET SHOWPLAN_TEXT/ALL), someone may be able to
suggest something.
Simon
[Back to original message]
|