I ran an Alert to update 168 records and then ran a query in the Advanced Report Studio to see if the data was updated correctly. There appeared to be a delay of 8 minutes from when the Alert began to when the database record was actually updated. This is the method used by the vendor whom deployed the software and one I have also used to make other data corrections. I've not noticed this with the previous alerts. Can you help me understand why there is a delay and how long I should wait before checking data?
ALERT 10029
.docx
Download DOCX • 14KB
The alert Before SQL is attached.
After looking at the SQL that you are running you are updating some really large tables r5events, r5translines and r5propertyvalues Also the SQL statements where clause for r5propertyvalues does not limit the data to the entity 'EVNT' which means it will not use the index to help it run more efficiently Not knowing the Business rules that are in place or the size of the tables this could affect the cost (time it takes) to run the data through the alert. Hope this helps.