[OSM-dev] Potlatch update

Robert (Jamie) Munro rjmunro at arjam.net
Wed May 9 16:06:10 BST 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kristian Thy wrote:
> On Tue, May 08, Frederik Ramm wrote:
>> Someone once told me that Mysql is too dumb to use an index inside an OR 
>> condition and that one would therefore be better off with UNIONs.
> 
> Dumb question: Doesn't MySQL come with a query analyzer?

Your talking about the database that can't figure out that:

 delete from table;

means empty the table completely, not one row at a time, so it has an
extra SQL instruction:

 truncate table;

that does the exactly the same thing, only quicker.

Robert (Jamie) Munro


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGQeNfz+aYVHdncI0RAsFOAKDpRU13Skt/rU0ac2GGuvPuuMoX6ACeK0Op
BhhH+LyJkN1W2HU/2D5eJyE=
=3O4q
-----END PGP SIGNATURE-----




More information about the dev mailing list