[Qgis-developer] [Qgis-user] Caching remote postgis layers?

[Nathan Woodrow]

Hey Willem,

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.

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?

- Nathan


On Tue, Aug 6, 2013 at 2:44 AM, Willem Buitendyk <willem at pcfish.ca> wrote:

> 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?
>
> Willem
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20130806/1258248e/attachment.html>