[postgis-devel] Transform() PROJ4 cache patch

[strk at refractions.net]

There's a SPI_execute() call that should be changed to SPI_exec
or compile-time switched (SPI_execute was introduced in 8.0).

Apart from that I think you can commit.
Thanks!

--strk;

On Sat, Nov 05, 2005 at 04:03:33PM -0000, Mark Cave-Ayland wrote:
> 
> > -----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.