<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi Willem<br>
<br>
Another thing to explore is the offline editing plugin. It caches
postgis layers to a local spatialite database and can even be used
to synchronise edits between local spatialite db and remote
postgis db.<br>
<br>
>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?<br>
<br>
The plugin saves WMS as local rasters and WFS as local vectors.
This is similar to save as local vector / raster file by hand.
However the plugin is more convenient because it manages the local
storage and the reference to the remote uri. It has some other
nice features like synchronizing / offlining in a graphical way.
Btw., we hope to include this plugin (a C++ one) into the main
repository after 2.0 feature freeze is over.<br>
<br>
Regards,<br>
Marco <br>
<br>
On 06.08.2013 03:20, Brent Wood wrote:<br>
</div>
<blockquote
cite="mid:1375752039.17530.YahooMailNeo@web122004.mail.ne1.yahoo.com"
type="cite">
<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 face="Arial" size="2"> <b><span
style="font-weight:bold;">From:</span></b> Nathan
Woodrow <a class="moz-txt-link-rfc2396E" href="mailto:madmanwoo@gmail.com"><madmanwoo@gmail.com></a><br>
<b><span style="font-weight: bold;">To:</span></b>
Willem Buitendyk <a class="moz-txt-link-rfc2396E" href="mailto:willem@pcfish.ca"><willem@pcfish.ca></a> <br>
<b><span style="font-weight: bold;">Cc:</span></b>
qgis-user <a class="moz-txt-link-rfc2396E" href="mailto:qgis-user@lists.osgeo.org"><qgis-user@lists.osgeo.org></a>;
<a class="moz-txt-link-rfc2396E" href="mailto:qgis-developer@lists.osgeo.org">"qgis-developer@lists.osgeo.org"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:qgis-developer@lists.osgeo.org"><qgis-developer@lists.osgeo.org></a> <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
moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true"
ymailto="mailto:Qgis-user@lists.osgeo.org"
href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-developer mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Dr. Marco Hugentobler
Sourcepole - Linux & Open Source Solutions
Weberstrasse 5, CH-8004 Zürich, Switzerland
<a class="moz-txt-link-abbreviated" href="mailto:marco.hugentobler@sourcepole.ch">marco.hugentobler@sourcepole.ch</a> <a class="moz-txt-link-freetext" href="http://www.sourcepole.ch">http://www.sourcepole.ch</a>
Technical Advisor QGIS Project Steering Committee </pre>
</body>
</html>