[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

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/




More information about the dev mailing list