[Qgis-user] SpatiaLite data rendered slowly

[Árni Geirsson]

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/543c994a/attachment.html>