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

Using Mysql you could do this 
SELECT * FROM table ORDER BY RAND() LIMIT 1;

[download]
to select one record at a time, or leave out the LIMIT to select all records.

Replies are listed 'Best First'.
Re^4: Strategy for randomizing large files via sysseek
by quai (Novice) on Sep 09, 2004 at 18:21 UTC
    MySQL does that by first creating a temp-table, then give every row a random number, and then sort it.. Not a good idea :)
[reply]

In Section Seekers of Perl Wisdom