A 3rd part app is using 'our' database views. Basically flow looks like this:
- New Row is inserted to Results table;
- Insert new row to Event table (with information about new result).
The 3rd part is saying that sometimes they receive an event (also indexed view) but when they check indexed view for result it returns null. Asked programmers if that situation is possible from code side, they said it is not possible because the program wait with inserting row to Event table until result is finally saved (committing transaction).
From timestamps I see it takes ms from Result to Event. Like Result is saved at .320 and Event is saved at .350.
So my question is: Is it possible that it take so much time for indexed views to be actualized or maybe they are being actualized during insert statement?