[OSM-dev] getnodes query optimization

[Raphaël Jacquot]

Immanuel Scholz wrote:
> Hi,
> 
> 
>> simply add a flag to the dataset that states when something is current.
>> SteveC is under the impression that this will slow things down
>> unneccesarily: I feel that the 4x improvement it offers in selects would
>> be beneficial enough to make it a worthwhile change.
> 
> Please make sure, that you encapsulate everything correct into
> transactions when doing so.

which I've been saying since the begining.
if mysql doesn't support proper SQL transactions, then it is time to
ditch it in favor of something more powerful... (did I say postgresql ?) :D