-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 01/22/07 05:49, Peter Rosenthal wrote:
> Right,
>
> You also have to realize that your first query might return zero results,
> and MySQL (and maybe this is correct SQL behavior) balks at an empty value
> set "where table_id in ()".
>
> I would expect that giving the DBMS the whole picture of what you want to
> do, should allow it to make better decisions on how to retrieve the data.
>
> MySQL Inefficiencies like this seem to hit the performance of a highly
> normalized database design hard.
<SNARKY_REMARK>
Do MySQL "designers" even know what data normalization is?
</SNARKY_REMARK>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFtMt4S9HxQb37XmcRAn3LAKDQo5NK1Htd/QrQ6h15iBS8xZU2NgCfW/Ak
HBliUtTkRP0yH8MtuabNCjE=
=b8aT
-----END PGP SIGNATURE-----