|Subject:||FYI: order_by => \'RAND()' and cursor reset (kills STH) is bad|
(using MySQL as database) Create a result set and use order_by => \'RAND()' (random order). Grab a page of results and use the rows. Reset the cursor for this page and loop through the page's rows a few times. Get random results each time. Ha ha ha. :) Looking in DBIx::Class::Storage::DBI::Cursor it seems the "reset" method is killing the STH. Perhaps this should be warned about in the cursor documentation? Bonus points, is there another way to reset the cursor that that will keep the original STH and its original random batch of rows? Thanks for all the hard work!