Timeline for Optimizing query for large table with `rand()` ordering
Current License: CC BY-SA 3.0
7 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Dec 4, 2018 at 0:14 | answer | added | Curtis | timeline score: 4 | |
Dec 29, 2016 at 3:47 | history | tweeted | twitter.com/StackDBAs/status/814316975518261248 | ||
Dec 27, 2016 at 20:22 | comment | added | Bernd Buffen | can you add something like this WHERE [your conditions] AND [id or accountID] >= rand()*maxid LIMIT1; where maxid can be a old id so you not must get the actual maxid every time | |
Dec 27, 2016 at 19:20 | vote | accept | Nick Gotch | ||
Dec 27, 2016 at 2:05 | answer | added | Rick James | timeline score: 1 | |
Dec 27, 2016 at 1:03 | comment | added | IT Thug Ninja | There are many good questions and articles out there about this topic... here are two from SO just as FYI in case you find methods mentioned (even in unaccepted other answers per each question).... stackoverflow.com/questions/1823306/… and stackoverflow.com/questions/1244555/… | |
Dec 26, 2016 at 20:59 | history | asked | Nick Gotch | CC BY-SA 3.0 |