Timeline for Increase Tiles Caching Speed (TileStache)
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 12, 2016 at 6:28 | comment | added | Hasan Mustafa | Will do that, thanks for the help. I didn't know about materialized views before and they are pretty awesome at times (on a test table and query). | |
| May 12, 2016 at 6:21 | comment | added | Alex Leith | Well if that's the case then optimising the database wont help. Look deeper. | |
| May 12, 2016 at 5:57 | comment | added | Hasan Mustafa | I tried building materialized views on my roads table but that didn't have any discernible effect. I think that's because my query for higher zoom levels (Zoom 14 plus) for road data is returning the whole table. | |
| May 11, 2016 at 6:11 | comment | added | Alex Leith | Yep. Try subsetting and saving that as a materialized view, with a spatial index, and then your select should be really basic (select geom from TABLE where intesects..) | |
| May 11, 2016 at 6:10 | comment | added | Hasan Mustafa | Ok, I'll give it a shot, my query on the roads table is particularly slow, mostly because I have over 1.4 million rows there. | |
| May 11, 2016 at 6:08 | comment | added | Alex Leith | You can't do that. Make one for your slowest query, maybe for a single zoom level, and see if it makes i faster. | |
| May 11, 2016 at 6:05 | comment | added | Hasan Mustafa | So if I make a single MV based of all my queries will that work? | |
| May 11, 2016 at 6:01 | comment | added | Alex Leith | Well if it's not fast enough, perhaps making views of the slowest select statements will be able to improve it. Note that you can make a MV of any select statement, including from multiple tables if you need. | |
| May 11, 2016 at 5:23 | comment | added | Hasan Mustafa | I have 11 different tables that I am querying to make my tiles, does that mean I'll have to make 11 materialized views? And my queries change based on Zoom Levels as well. | |
| May 11, 2016 at 5:12 | history | answered | Alex Leith | CC BY-SA 3.0 |