+1 to local cache as Select at ID would just confuse people.<div><br></div><div>- Nathan<br><br><div class="gmail_quote">On Fri, Dec 2, 2011 at 5:28 PM, Andreas Neumann <span dir="ltr"><<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi,<br>
<br>
Fyi - Jürgen just included an option in the Postgis Table Connection dialogue allowing to cache a Postgis table or view locally. There is a separate column called "Select at ID" (german "Abfrage nach ID") which is checked by default. If you disable this checkbox it will activate "local caching" of the table data. Of course this is limited to the amount of memory you have in your machine, but it is great improvement for slower Postgis views or slower connections.<br>
<br>
Please try it out and report bugs, if any.<br>
<br>
I am not yet fully convinced if people understand what "Select at ID" means ... any suggestions? It is derived from the fact that if a provider has getFeatureAtId available it will not cache locally, otherwise it will. I would prefer "local cache" as a column name, but then the meaning of the checkbox would have to be reversed.<span class="HOEnZb"><font color="#888888"><br>
<br>
Andreas</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
On Thu, 24 Nov 2011 15:44:35 +0100, Andreas Neumann wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
thats interesting - the same table in Spatialite or Shape scrolls much<br>
faster (at least 10 times faster)<br>
</blockquote>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
so yes - it seems to be related to the PostgreSQL datasource.<br>
</blockquote>
<br>
(commit) 90481072 might help with this a bit.<br>
<br>
</blockquote>
<br>
it helps for repeated scrolling. Initial scrolling is equally slow<br>
than before, but if I scroll back and forth to records that had<br>
already been viewed, it scrolls faster.<br>
<br>
Thanks, Jürgen!<br>
<br>
Andreas<br>
</blockquote>
<br>
-- <br>
--<br>
Andreas Neumann<br>
Böschacherstrasse 10A<br>
8624 Grüt (Gossau ZH)<br>
Switzerland<br>
______________________________<u></u>_________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/qgis-<u></u>developer</a><br>
</div></div></blockquote></div><br></div>