4 ms·
Considering the access patterns of the clients are well known, would it make sense to populate new tables as materialized views before Sending it to the clien
by kandros 3y ago
Considering the access patterns of the clients are well known, would it make sense to populate new tables as materialized views before Sending it to the client or you think is not worth it perf wise?
- stpn 3y agoWe use the client-side sqlite as part of making the app work locally and offline, so it wouldn’t make sense. The materialized view isn’t a huge perf problem for now, and I expect we’d switch to using triggers or similar without too much difficulty.