Posted by J.O. Aho on 03/06/07 09:14

Geoff Berrow wrote:
> Message-ID: <op.torcq8kbqnv3q9@misant> from Rik contained the following:
>
>> Raj, look up what crossposting and multiposting is, and why it's frowned
>> upon
>
> To be fair, /I/ would have been interested in a purely SQL solution even
> though I'm only reading php groups. (my solution would have been to
> query with a LIMIT 0,n and do the rest with PHP).

I would have done everything in SQL, as you never know where the server may be
regarding the web-server, if they are at a long distance from each other, you
really want as little traffic as possible between them.

Using limit will give you in the sql query before the result has been randomly
selected, you will always have a random of a subset of the whole, and that
wasn't what the OP did ask for.


> However it /is/ preferable to post in one relevant group first and then
> widen your search in other groups if you do not get a solution.

Yes, but then you do wait at least more than one minute before posting in
other ng.


--

//Aho

[Back to original message]