[OSM-dev] Potlatch update

Richard Fairhurst richard at systemeD.net
Tue May 8 21:10:56 BST 2007


Frederik Ramm wrote:

> [big hairy SQL query snipped]
> That might work?

That's loads better. Thanks a lot. I'll see how that affects the  
possibility of doing some POI stuff for Potlatch...

> 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.

Looking at http://bugs.mysql.com/bug.php?id=11989, it looks like  
you're right - at least for MySQL 4, which is what I'm using. It's  
been fixed in MySQL 5.

What version of MySQL are we using on the db server?

cheers
Richard




More information about the dev mailing list