On Fri, Aug 9, 2013 at 11:30 AM, Andrea Aime
<andrea.a...@geo-solutions.it>wrote:
> Hi,
> I have been doing some quick tests with the spatialite store, while it
> seems I can open data just fine, a simple scalability tests made with ab
> against geoServer, making the same request over and over using 4-8 threads
> seems to suggest there are serious scalability issues, the CPUs are barely
> used.
>
> Searching around it seems a well known problem with sqllite, and
> apparently the solution would be to share the same connection among
> different threads:
>
> http://stackoverflow.com/questions/10707434/sqlite-in-a-multithreaded-java-application
>
> Has anyone experiences on this topic?
>
Following up on this, it seems that sqllite needs explicit commands to work
in threaded mode:
http://www.sqlite.org/threadsafe.html
However it seems that the stable Xerial driver does not have a way to
select this option:
https://groups.google.com/forum/#!topic/xerial/GF446u1HSBA
No idea if a more recent (snapshot, beta) version added this support, but
it does not look like it did:
https://bitbucket.org/xerial/sqlite-jdbc/src/tip/CHANGELOG?at=default
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
