[postgis-devel] Transform() PROJ4 cache patch

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-devel-bounces at postgis.refractions.net 
> [mailto:postgis-devel-bounces at postgis.refractions.net] On 
> Behalf Of Mark Cave-Ayland
> Sent: 04 November 2005 11:42
> To: 'strk'
> Cc: postgis-devel at postgis.refractions.net
> Subject: RE: [postgis-devel] Transform() PROJ4 cache patch

(cut)

> Okay. Keeping everything in the original style (everything in
> lwgeom_transform.c) patch means it's now just a cut and paste 
> job to keep the old code. When I get a moment, I'll rework 
> the patch and post it back to the list for final review before commit.


Hi strk,

Hopefully this should be the last version before commit - I've attached the
patch against CVS HEAD for testing. Here are the timings from a different
box:


BEFORE

postgis11=# \timing
Timing is on.
postgis11=# select count(transform(geom, 4326)) from test;
 count
--------
 500000
(1 row)

Time: 445359.010 ms


AFTER

postgis11=# \timing
Timing is on.
postgis11=# select count(transform(geom, 4326)) from test;
 count
--------
 500000
(1 row)

Time: 5077.462 ms


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com 
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: transform_cache_postgis-head.patch
Type: application/octet-stream
Size: 13426 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20051105/a8428599/attachment.obj>