in reply to Re^3: Strategy for randomizing large files via sysseek
in thread Strategy for randomizing large files via sysseek

MySQL does that by first creating a temp-table, then give every row a random number, and then sort it.. Not a good idea :)
  • Comment on Re^4: Strategy for randomizing large files via sysseek