[Qgis-user] SpatiaLite data rendered slowly

[Árni Geirsson]

One observation regarding this problem: Both the shapefile and SpatiaLite
database are on a NAS box. If I move the SpatiaLite file to a local drive,
it renders instantly like the shapefile. So the question is: What is it
about being stored on a NAS box that throttles down the speed of SpatiaLite
but does not affect shapefiles?

Árni


Árni Geirsson
*Alta ehf* // +354 582 5000 // +354 897 9549
www.alta.is  // Alta á Twitter <http://twitter.com/alta_ehf> // Alta á
Facebook <http://www.facebook.com/pages/Alta/161795813838691?v=wall>

On Mon, Sep 14, 2015 at 1:56 PM, Árni Geirsson <arni at alta.is> wrote:

> Hi
> I have polygon data in a shapefile that is rendered instantly on the
> screen when I zoom and pan. Now I want to use the more advanced
> capabilities of SpatiaLite and I have loaded the data into a SpatiaLite
> database. Rendering the SpatiaLite data on the screen is much slower. The
> polygons appear one by one and refreshing the map takes several seconds.
> There are about 19.000 fairly simple polygons in the table, which should
> not be very demanding.  I have tried loading the data into SpatiaLite
> both with the DB manager and the SpatiaLite-GUI application with the same
> slow result.
> I tried loading the same data into PostGIS on localhost and that is as
> quick as the shapefile.
> I have created a spatial index on the SpatiaLite table but that did not
> improve the slow rendering.
>
> What am I doing wrong?
>
> Thanks
>
> Árni
>
> Árni Geirsson
> *Alta ehf* // +354 582 5000 // +354 897 9549
> www.alta.is  // Alta á Twitter <http://twitter.com/alta_ehf> // Alta á
> Facebook <http://www.facebook.com/pages/Alta/161795813838691?v=wall>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150914/3bc65a6f/attachment.html>