Re: [Qgis-user] columns in spatialite

[Micha Silver]

On 11/13/2015 01:51 AM, Matthias Kuhn wrote: On 11/12/2015 07:25 PM, Alex M wrote: SQLite stores the geometries differently than Spatialite. http://www.gdal.org/drv_sqlite.html FORMAT=WKB/WKT/SPATIALITE Biggest side effect I can think of is that you can't use the spatialite query mechanisms on WKB/WKT without converting. Which includes spatial indexes (not sure anything in QGIS utilizes these currently). I'm also An index will make a difference when you make a select with a bounding box like it's done with every repaint. Good to know, thanks! -- Micha Silver Arava Drainage Authority +972-523-665918

_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user