[postgis-users] Small speed comparison

[Markus Schaber]

Hi,

I just ran a small test (see attached file) in java, fetching the same
large table from 1.0CVS, 0.9.1 and 0.8.1. The timings are:

Creating JDBC connection to lwgeom... fetching...
Result 0: 83 rows fetched in 22.572s.
Result 1: 83 rows fetched in 22.187s.
Result 2: 83 rows fetched in 21.975s.
Result 3: 83 rows fetched in 23.475s.
Creating JDBC connection to hwgeom09... fetching...
Result 0: 83 rows fetched in 270.259s.
Result 1: 83 rows fetched in 271.803s.
Result 2: 83 rows fetched in 272.83s.
Result 3: 83 rows fetched in 271.672s.
Creating JDBC connection to logigis... fetching...
Result 0: 83 rows fetched in 276.982s.
Result 1: 83 rows fetched in 273.021s.
Result 2: 83 rows fetched in 273.16s.
Result 3: 83 rows fetched in 272.399s.

As expected, 0.9 and 0.8 (which use EWKT as canonical rep) are nearly
equal, while lwgeom using hexwkb is much faster. Due to the tcp overhead
and the java parsing, the difference is not as large as in the
server-side benchmark I posted last week, but I think a speedup factor
of 12 is still notable.

Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios at logi-track.com | www.logi-track.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: LargeGeomSpeed.java
Type: text/x-java
Size: 2250 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050209/ce5711b4/attachment.java>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050209/ce5711b4/attachment.pgp>