"Shashank Tripathi" <shashank.tripathi@gmail.com> writes:
>> select something from othertable;
>> select * from table where table_id in (?, ?, ?, ?, ?, ?, ?, ...)
> This is what MySQL's CEO Martin said in an interview on Slashdot. If
> we can manage two queries as above through, say, a PHP application,
> with each executing in 0.004 seconds, then an optimized subquery needs
> to be beat the 0.008 mark to be a viable alternative.
That certainly *should* be possible, because the subquery approach
requires one less network round-trip, and less data marshaling/
transmission/demarshalling/back-the-other-way. If MySQL is seriously
making that argument as a reason why they need not put work into
subselects, you should be hearing strong echoes of their former
positions about "you don't need foreign keys" and so on.
regards, tom lane