[Qgis-user] Reading of large SQLite files

[Andrea Peri]

Hi,

this issue is due to a choose of the spalite provider.
Splite is really fast to use the data, but when add a new layer to the
canvas, it need to
analyze all the dataset to understand the largex bbox.
To do this it could take also many minutes.
After this phase it will be more fast to use it.

To resolve this issue, in splaite 3.0 was added a new system table named
statistics.
It allow to take very fast the BBOX of a dataset without to analyze
realtime the dataset himself.

Unfortunately the driver splite of qgis is still to splite 2.4.0 so don't
use this statistics table.

But a good news is that Furieri (the author of splite) is working on a new
qgis driver for splite 4.0 that
will use this statistics table .
and after the add of an uge table will be more fast.

Regards,

Andrea.



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121023/ae7fe3b9/attachment.html>