Not sure about SQL but on the bigger toys I normally work with I pull a record count & then generate X random selects between 0 & count to pull actual data.
But then I haven't really seen PerformancePartitioning & DatabaseFragmentation used on any PHP scripts either.
|