[Qgis-developer] Postgis Caching - Enhancement

[Martin Dobias]

Hi Alex

On Tue, Apr 1, 2014 at 6:51 AM, Alex Mandel <tech_dev at wildintellect.com> wrote:
> Searching tickets I don't see this one, but wanted to check that it
> wasn't on the roadmap.

There were plans to add such functionality for ages, but nothing ever
got into the codebase... Issue #3200 has an old patch attached, mainly
for an inspiration.

I would love to have this functionality in QGIS - not only for
PostGIS, but more generic framework for caching of vector features. I
believe this will bring another boost to the rendering performance,
not only for remote connections, but also for local data sources that
are non-trivial to parse or that do not support spatial index or
attribute index natively.

It would be great to have a common framework in QGIS that would do:
1. feature storage
2. spatial indexing  (R-tree)
3. attribute indexing (B-tree)
4. full-text indexing
All that based on pages, with maximum allowed memory usage, with
ability to swap pages to disk etc. SQLite looks like a good backend
for such thing.

Regards
Martin