search

tilemill-project / tilemill

TileMill is a modern map design studio
https://tilemill-project.github.io/tilemill/
BSD 3-Clause "New" or "Revised" License
3.12k stars 528 forks source link

loading fields for templates can take a really long time #1105

Closed ajashton closed 12 years ago

ajashton commented 12 years ago

especially on OSM projects with many postgres layers.

springmeyer commented 12 years ago

I've noticed this too. I'll need to look closer to be sure but I think the issue is that the actual layer query is executed just to get the field metadata. This is due to a flaw in the node-mapnik api from early days of tilemill: https://github.com/mapnik/node-mapnik/issues/68.

Fixing it will break a number of things so I've been watching for the right time to move on this - and it may be now :) given how annoying I can imagine this is for you.

ajashton commented 12 years ago

Not sure if this is the same issue, but I am completely unable to change the interactivity layer. When I select a different layer, it just hangs with the grey spinning overlay. After a while I get the "no connection to server" error, even though TileMill is still running.

springmeyer commented 12 years ago

yes, very well may be a postgres timeout because the query is so massive - because its selecting the data without a bbox filter and the interactivity UI is asking for every single field column - a double evil.

yhahn commented 12 years ago

FYI I only plan on adding the "Cancel" button here (to stop the tile server) for now.

springmeyer commented 12 years ago

@yhahn - sounds good.

springmeyer commented 12 years ago

re-opening, there is more here to discuss and research.

springmeyer commented 12 years ago

actually, nm, will create new tickets for what I am seeing.