<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi Willem,</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Why can you not save such a layer or a selection from such a layer, as a local shapefile (or other supported format). is this not effectively a "local cache"? Delete/overwrite when you desire.<br></div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Where is the performance bottleneck? Postgis, network, QGIS? Just creating a local cache will not necessarily speed things up, if your database is on a fast server with a fast network, it may even get slower.<br></div><div style="color: rgb(0, 0, 0); font-size: 16px;
font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Sourcepole have developed (for NIWA, New Zealand) a plugin that supports local caching of WMS & WFS data sources. This could probably be adapted to support other input formats. Marco Hugentobler did the coding for this - he can perhaps comment?</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">As Nathan says, caching a local snapshot of a dynamic, multi-user database will result in something that gets out of sybc with the
source pretty quickly. Caching a local copy of a largely static database is relatively safe.</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Cheers</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Brent<br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font
size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Nathan Woodrow <madmanwoo@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Willem Buitendyk <willem@pcfish.ca> <br><b><span style="font-weight: bold;">Cc:</span></b> qgis-user <qgis-user@lists.osgeo.org>; "qgis-developer@lists.osgeo.org" <qgis-developer@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, August 6, 2013 11:07 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Qgis-user] Caching remote postgis layers?<br> </font> </div> <div class="y_msg_container"><br><div id="yiv7173009880"><div dir="ltr">Hey Willem,<div><br></div><div>I'm not aware of a feature like that. The best place to ask this question to see if anyone is working, or planning to work, on it is the developer list. I have copied it in so it show up there too.</div>
<div><br></div><div>Caching could be done by storing the returned results in a memory spatialite database. The tricky thing is knowing when to get any new results from the postgis database when things have changed on the database. How does Manifold handling viewing an area, updating something using SQL on the database (not though Manifold) and then looking at that area again?</div>
<div><br></div><div>- Nathan </div></div><div class="yiv7173009880gmail_extra"><br><br><div class="yiv7173009880gmail_quote">On Tue, Aug 6, 2013 at 2:44 AM, Willem Buitendyk <span dir="ltr"><<a rel="nofollow" ymailto="mailto:willem@pcfish.ca" target="_blank" href="mailto:willem@pcfish.ca">willem@pcfish.ca</a>></span> wrote:<br>
<blockquote class="yiv7173009880gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I've noticed looking at the roadmap that caching remote postgis data is not on the list. I love qgis but a lot of my work involves connecting to a remote postgis database. The speed of navigating a large dataset is, at the moment, rather unbearable. I also use Manifold GIS and the difference in speed is shocking, presumably because Manifold is caching the dataset. This seems like it should be a relatively easy thing to implement. Is there interest on this board for this feature? I was thinking at taking a stab at contributing to the source code but am wondering about methods to achieve data caching most efficiently. Look forward to others thoughts? Or maybe I missing something that is already in place?<br>
<br>
Willem<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a rel="nofollow" ymailto="mailto:Qgis-user@lists.osgeo.org" target="_blank" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div><br></div></div><br>_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br><br><br></div> </div> </div> </div></body></html>