2 ms·
That's really useful, thanks. My rules of thumb are based entirely off experiments I've done with Datasette, which tends towards ad-hoc querying, often without
by simonw 5y ago
That's really useful, thanks.
My rules of thumb are based entirely off experiments I've done with Datasette, which tends towards ad-hoc querying, often without the best indexes and with a LOT of group-by/count queries to implement faceting.
You've made me realize that those rules of thumb (which are pretty unscientific already) likely don't apply at all to projects outside of Datasette, so I should probably keep them to myself!