Workaround · API & developer experience · Blocks work
No logical OR in queries, forcing redundant overlapping downloads
1 source thread · first seen 2022-02
Summary
Without OR support the user fires multiple queries with cursors to simulate it while syncing a local database. Overlap between results can reach 100 percent, wasting time and server resources.
- Affects
- developer syncing a local database
- Workaround
- Run several queries with cursors and merge the results
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“I have to fire multiple queries (with multiple requests with cursor for each of them) to simulate the OR”