On 23.07.19 20:23, Stas Malyshev wrote:
Also, with live updates, long queries create other technical challenges (if query is running for 2 hours, the database has basically to keep the snapshot it runs on for 2 hours, which may make it much less efficient).
Wait, does that mean that the current query service actually gives each query a consistent view of the database for up to 60 seconds? I always assumed that WDQS didn’t give you the same transactionality guarantees as e. g. MySQL, because how could that possibly work with such a high query and update rate…
Cheers, Lucas