So Jody and I have been integrating data-exp with geoserver, on the
wms-merge branch, and spent the day compiling a few stats comparing the
old to the new. There are still a few little rough edges to work, this is
just GetFeatures with no filtering. To get this up to a state to put out
we need to do a few more fixes, we're still failing a few cite tests.
And we also want to fully integrate the new postgis 0.8 with geos, since
it's been released, and will make spatial queries fly. But yes, this
shows that the new geotools data api is much better. Thanks to Gabriel
and IanS for the initial ideas, Jody and Sean for tons of implementation
work, turning the ideas into a workable api, and the whole geotools team
for support and ideas throughout.
---------- Forwarded message ----------
Date: Tue, 25 Nov 2003 21:03:32 -0500 (EST)
From: Chris Holmes <cholmes@anonymised.com>
To: Jody Garnett <jgarnett@anonymised.com>
Subject: stats
First a description of the feature sets:
Seven, from cite, 7 features, two attributes (both small geometries).
water 117 features, 7 attributes, one geometry (small to medium).
states 49 features, 200+ attributes (census data), big geometries.
landmark 2063 features, 9 attributes, small geometries.
rail 15067 features, 5 attributes, smallish geometries.
road 91317 features, 20 attributes, smallish geometries.
I did 5 times each for 1.0.0 and wms-merge, for all but the two biggest.
You can do the averaging. road and rail have two data points each.
old new
seven
2.105 1.882
0.403 0.265
0.292 0.233
0.278 0.219
0.431 0.269
water
1.636 0.53
1.287 0.514
1.172 0.518
1.475 0.512
1.185 0.521
states
28.888 3.401
19.905 2.431
19.8 2.364
18.041 2.254
18.981 2.533
landmark
13.968 4.515
12.572 4.43
13.106 4.412
12.601 4.618
12.526 4.451
rail
226.351 13.315
224.964 12.986
road
out of memory 126.405
(at 30000 and 149.385
and 50000 features)
So the new geoserver is faster at every level, more than 15 times faster
for bigger feature sets, and able to handle far more features than before.
Oh, and just did a pgsql2shp dumps on the bigger features:
rail: shp=2.4M dbf=1.1M
road: shp=7.8M dbf=16.2M
states: shp=182k dbf=390k
water: shp=107k dbf=9.2k
landmark: shp=504k dbf=218k
Chris