Hi Guys, I have a collection built that could potentially have 10,000 or more records.
I need to query this catalog and grab 20 random records from it. What would be the best way to do this? Right now all I can think to do is to perform a cfsearch on the catalog with criteria="*" (wild card), then do a sql query on that recordset, using some kind of randomization function and putting a limit on how many rows are fetched (maxrows=20"). Is there a more direct way to do this when I perform the original cfsearch on the collection? That way the initial query doesn't need to grab every single record? This function will be executed fairly often so I want to reduce the overhead it creates. Thanks! -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
