[OSM-dev] Patch to speed up planet dumps

Tom Hughes 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 mailing list