<html style="direction: ltr;">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
text="#000000" bgcolor="#FFFFFF">
<br>
<br>
<div class="moz-cite-prefix">On 11/13/2015 01:51 AM, Matthias Kuhn
wrote:<br>
</div>
<blockquote cite="mid:56452614.8070600@opengis.ch" type="cite">
<pre wrap="">
On 11/12/2015 07:25 PM, Alex M wrote:
</pre>
<blockquote type="cite">
<pre wrap="">SQLite stores the geometries differently than Spatialite.
<a class="moz-txt-link-freetext" href="http://www.gdal.org/drv_sqlite.html">http://www.gdal.org/drv_sqlite.html</a>
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
</pre>
</blockquote>
<pre wrap="">An index will make a difference when you make a select with a bounding
box like it's done with every repaint.
</pre>
<br>
</blockquote>
<br>
Good to know, thanks!<br>
<br>
<br>
<div class="moz-signature">-- <br>
<div dir="LTR">
Micha Silver<br>
Arava Drainage Authority<br>
+972-523-665918
</div>
</div>
</body>
</html>