3 ms·
It depends upon the process which was doing the search. For example, does some automated process search for possible duplicates of a given field, nearly immedi
by rossdavidh 7y ago
It depends upon the process which was doing the search. For example, does some automated process search for possible duplicates of a given field, nearly immediately, and need to know whether the returned set includes the new record (or not), so it can know whether "1" means "1 duplicate" or "no duplicates". That's just an example I made up on the spot, but there are more possibilities. If storing a record sets off a chain of events, and one of those might do a search, then the sync between index and database might be critical.
Or, of course, depending on the system, it might not.