Chiming in late here.
It probably makes sense to recompile the customized xerial driver with the
threading options, and whatever other options we think make sense. This
should be relatively straight forward, except for windows, where in my
experience trying to compile any library is never that straight forward.
What would be great is if we had a volunteer who would handle the windows
build bits, ideally someone with experience compiling distributable
libraries that require dynamic linking.
On Fri, Aug 9, 2013 at 8:15 AM, Andrea Aime <andrea.a...@geo-solutions.it>wrote:
> 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
>
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
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
