wt.occurrence.StandardOccurrenceService.isUniqueOrDeleted()這個API會觸發select count(*)語句是必要的,造成 Database很大的 Loading

[毓謝]

wt.occurrence.StandardOccurrenceService.isUniqueOrDeleted()這個API會觸發select count(*)語句是必要的

RE PTC Case C12591456 ref 00DAYLPa 500FcOWrq ref .msg.zip

[BrentLi]

[Translated to English]

wt.occurrence.StandardOccurrenceService.isUniqueOrDeleted() triggers the "select count(*) ..." SQL statement. Invoking the API in a loop will trigger a lot of "select count(*) ..." SQL statements in a short period. This results in the high DB CPU usage ratio and has the negative impact for the DB server.

Is it possible to not trigger the "select count(*) ..." SQL statement when invoking wt.occurrence.StandardOccurrenceService.isUniqueOrDeleted()?

[毓謝]

if the sql script don't use 
 SELECT COUNT(*) FROM PartUsesOccurrence A0 WHERE ((A0.usesOccurrenceDataIdentifier = @P0))

Change to

IF EXISTS (SELECT idA2A2 FROM PartUsesOccurrence  WHERE (usesOccurrenceDataIdentifier=@P0))

PRINT 'EXIST'

ELSE

PRINT 'NOT EXIST'

GO

This is a good way to solve this problem, but I don't know how to change this script.

[olivierlp]

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.