I have an application where I need to select certain random values
from a select set. The obvious way to do it is via cursors. That is,
I perform the select, generate the random numbers, then seek the
cursor that position in the set to retrieve the row. The data set is
*way* big and will not fit into memory, so that's not a viable option.
Right now, I'm doing a COUNT() on the dataset, then performing
repetitive "SELECT ... LIMIT N,1" where N is my random number.
Needless to say, this is very inefficient!
Is there some good way to emulate the cursor functionality from the
Perl DBI interface?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@stripped Rockville, MD +1-301-545-6996
PGP & MIME spoken here http://www.kciLink.com/home/khera/
