3 ms·
In this case my database is 500KB in size so I'm not thinking about query performance at all. I've run into horrific performance problems with order by random
by simonw 4y ago
In this case my database is 500KB in size so I'm not thinking about query performance at all.
I've run into horrific performance problems with order by random() in larger databases.
I actually suggested the SRANDMEMER feature that was added to Redis as a result of one of those projects! Details here: https://simonwillison.net/2009/Dec/20/crowdsourcing/ https://simonwillison.net/2009/Dec/20/crowdsourcing/