Hacker News new | ask | show | jobs
by K2L8M11N2 1479 days ago
I can't think of a reason why getting an article with ID of randomIntBetween(0, count(articles)) would be slow (maybe UUID primary keys?)
1 comments
Sohcahtoa82 1479 days ago
Even if you used UUIDs, couldn't you just "select count(id) from articles" to get the list of articles, generate a random number between 0 and the count, then "select id from articles offset {index}"?
link