[OSM-dev] Proposed database improvement

[SteveC]

* @ 31/08/06 12:04:27 PM dave at earth.li wrote:
> On Thu, Aug 31, 2006 at 11:54:35AM +0100, Nick Hill wrote:
> > In conclusion, David's suggestion of using a union is slightly faster 
> > than my idea of using a temporary table. (I am used to MySQL <4.1 so am 
> > not particularly familiar with sub-queries). This may or may not be the 
> > case when using larger numbers of selects, as my solution replicated 
> > indexes on the temporary table so could be more scalable.
> 
> I had forgotten that mysql didn't used to be able to do this sort of
> thing. The advantange of my solution is that it is a single query, so
> can be inserted in place of the current one in the code.

deployed

seems a bit faster to me! Thanks guys.

this really is the last thing I'm giong to back port to the old
codebase. honest.

have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/