top | item 39960285 (no title) kandros | 1 year 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? discuss order hn newest stpn|1 year ago We 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.
stpn|1 year ago We 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.
stpn|1 year ago
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.