Martin Desruisseaux ha scritto: > Andrea Aime a écrit : >> Well, just to try out, maybe it's better to just setup a cache in the >> FactoryUsingSQL and think about changing all the rest if the results >> show there is a noticeable improvement. > > Actually, after a second though, I'm following exactly this path > (because turning the private method into a public one anoy me a little > bit). Martin, I've just added a couple of caches more and modified an sql statement to use a subquery. For the extensive test, down from 2 minutes to 35 seconds. :-) (look ma, no indexes!, really they add lots of size to the db and shave off only a handful of seconds more) Cheers Andrea
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
