Re: [Geotools-gt2-users] Rendering Oracle DB layer is very slow compared to MapViewer

[Ron L. <rli...@ya...>]

Andrea,

I tried to do the comparison as clean as possible (ofcourse).
I just timed the paint function of GTRenderer after multiple requests in a JSP servlet.
The initialisation of the Datastore is outside the timing comparison!
I initialise the Datastore only once.


For a map with 1 Oracle DB layer I timed a difference of 0.5 seconds for MapViewer and 1.5 seconds for Geotools.
For a map with 5 Oracle DB layers I timed a difference of 2 seconds for MapViewer and 3 seconds for Geotools.
So it seems that the overhead in the Geotools paint method is 1 second bigger for Geotools than for MapViewer independent of the number of layers.

Thanks.
Ron




________________________________
 From: Andrea Aime <and...@ge...>
To: Ron Lindhoudt <rli...@ya...> 
Cc: "geo...@li..." <geo...@li...> 
Sent: Friday, June 29, 2012 3:41 PM
Subject: Re: [Geotools-gt2-users] Rendering Oracle DB layer is very slow compared to MapViewer
 

On Tue, Jun 26, 2012 at 2:52 PM, Ron Lindhoudt <rli...@ya...> wrote:

Hi,
>
>
>I am comparing the rendering performance of Geotools (using Tomcat) against the Oracle tool MapViewer.
>My test shows Geotools is 2-3 times slower than MapViewer.

How is your test working? Is it a stand-alone "main"? 
If that's the case, you're comparing apples to... watermelons...

The stand alone app has to create and initialize the espg database, scan the classpath
for plugins, load classes, warm up the virtual machine, open connections to the database
before it can even start pulling the first query.

If you want to make a comparison do so between GeoServer (which is based on GeoTools,
but it's at least long lived that it does not end up paying all the startup costs on each
requests) and MapViewer

Cheers
Andrea
 -- 
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead

Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy

phone: +39 0584 962313
fax:      +39 0584 962313
mob:    +39 339 8844549

http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf