This component allows convenient selection of random rows. See
NOTE in DBIx::Class::Helper::ResultSet for a nice way to apply it to your
Currently this works by doing something akin to
SELECT TOP($x) from $table ORDER BY RANDOM()
Lots of people think this is slow. My own benchmarks show that doing the above,
for 10 rows in a table with just over 8 million rows, is nearly instant.
Although that was with SQL Server, and different databases will handle that
So please, if you have performance issues and want this to work with your
database, get in touch and I will do what I can to get it to work quickly enough
to suite your needs.