3 ms·
How to deal with eventual slow queries? I currently have a system with complex queries with a lot of joins where I had to create a custom materialized table Th
by d0100 2y ago
How to deal with eventual slow queries? I currently have a system with complex queries with a lot of joins where I had to create a custom materialized table
These queries also deal with permissions & realtime scheduling so endpoint caching doesn't solve it
Have gel users hit any performance issues, and how have they dealt with them?
- 1st1 2y agoWe're shipping a slow query log UI in this version to continuously monitor queries in your system. Our users do get performance issues, usually because they start really using our data model to its full potential, creating tens / hundreds complex access policies, 100-lines long EdgeQL queries etc. We have EXPLAIN command to deal with, and we also support our customers directly helping them understand and fix their system. All of the findings trickle down to the core product so that the rest can benefit too.