-----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----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
