On Fri, Aug 9, 2013 at 4:06 PM, Robin Pradel <r...@ivu.de> wrote:
> Sorry,****
>
> ** **
>
> I missed the other sections under http://www.sqlite.org/threadsafe.html ,
> sorry.****
>
> ** **
>
> You can call PRAGMA compile_options; to find these information. (
> http://www.sqlite.org/pragma.html#pragma_compile_options )
>
Ah, it seems stock sqlite shipping with Ubuntu already has threading on:
spatialite> PRAGMA compile_options;
the SPATIAL_REF_SYS table already contains some row(s)
ENABLE_COLUMN_METADATA
ENABLE_FTS3
ENABLE_RTREE
ENABLE_UNLOCK_NOTIFY
OMIT_LOOKASIDE
SECURE_DELETE
SOUNDEX
TEMP_STORE=1
THREADSAFE=1
But I'm betting it's not used when we access data via the xerial JDBC
driver (if it is, then it's a real disaster,
the thing does not scale up at all...)
> ****
>
> ** **
>
> I did not investigate the performance factor. If you provide some test
> data and scenarios, I could run some tests with my modified version and the
> origin one.****
>
> ** **
>
> Ideas for speeding up? Not really, sorry.****
>
> **
>
Oh, any large dataset with a few million features will do. Unfortunately I
cannot easily share what I have (it would take days to upload....).
> **
>
> Next to second dialect, we also need another DataStoreFactory. And because
> of the special dependencies (sqlite-jdbc-spatialite) in the SpatiaLite
> Plugin it becomes complicates to have both versions in one plugin.
>
Sigh, this is messed up...
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
