[OSM-dev] Patch to speed up planet dumps
tom at compton.nu
Mon Sep 3 08:38:20 BST 2007
In message <2fc2c5f10709030011t2acba474x8556a59915d2e41a at mail.gmail.com>
Martijn van Oosterhout <kleptog at gmail.com> wrote:
> 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.
Indeed. We have the same problem with the API for GPS points, but no
easy way to fix that one.
> Could somebody will ruby skills check over it to see if the syntax is ok?
It looks fine to me.
Tom Hughes (tom at compton.nu)
More information about the dev