> Although this might work in the particular application, but
> it is hardly ideal to make two queries, nor to load a long list
> of IDs. Is there a way to do it with a single query?
>
> 1)
Is your task really "time critical"?
How many records (IDs) do you expect to be returned using the first select?
How many kb will it take? Is the list size a real problem for your Internet
connection?
How often do you expect to release the select querry?
2)
what is your target database engine?
some databases allow "rand" in the select query.
see:
http://stackoverflow.com/questions/19412/how-to-request-a-random-row-in-sql
Petr
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
