[OSM-dev] Patch to speed up planet dumps
Martijn van Oosterhout
kleptog at gmail.com
Mon Sep 3 08:11:58 BST 2007
I looked at the planet dump code and its use of LIMIT/OFFSET is, well,
silly as well as terribly slow towards the end of the table. Attached
is a patch that uses the index on "id" to jump directly to the right
point in the table to continue from. Theoretically it should speed up
the dump, especially as the table gets larger.
Could somebody will ruby skills check over it to see if the syntax is ok?
Have a nice day.
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 3456 bytes
Desc: not available
More information about the dev