[Scythe42]

Tricky, because Kodi #2 has no way to know the value might have changed in the db...

Any chance for a way that magic number of 1 second can be made configurable for let's say Leia with an advanced setting maybe for the SQL DB? On Jarvis everything worked out fine, as it probably never cached to begin with here. 

With a large collection 1 second on the average NAS, RPi or whatever is really not enough to complete the query. It works fine with small DBs naturally or more powerful dedicated machine. But well, not everyone might have it and won't mind a longer delay here.

Some other information being outdated wouldn't be much of a problem.  But watched count is very annoying. You watch an episode, back up and immediately you see that there is something wrong - like you overlooked another episode.

Edit: Never mind, patched it myself and also replaced the views with tables updated by triggers for additional speed up...