[postgis-users] lwgeom wkb output slower in 1.0 RC1

strk at refractions.net strk at refractions.net
Tue Jan 18 01:46:09 PST 2005


I've changed unparse_WKB interface to take two additional arguments:
	size_t *retsize, byte hexform
Updated all code to use them and had WKBFromLWGEOM request non-hex
output. This way asBinary() output is from 3 to 5 times faster.

--strk;

On Tue, Jan 18, 2005 at 10:09:23PM +1300, Ralph Mason wrote:
> I need to dig this out.
> 
> I did a bunch of mods around this that 'deparse' a lwgeom directly to a 
> wkb (and I don't know the current state of the code, but removed the 
> preparse that was happening before it was feed to the lwgeom parser and 
> deparser)
> 
> I will have a hunt.
> 
> Ralph
> 
> >On Mon, Jan 17, 2005 at 08:22:10PM +0100, Aleksander Bandelj wrote:
> > 
> >
> >>WKB output in 1.0 RC1 is several times slower than in 0.9. Problem seems 
> >>to be the function WKBFromLWGEOM (used in AsBinary), which first 
> >>serializes lwgeom to hex string and then parses the string instead of 
> >>writing out WKB directly. Are there any plans to optimize this for 1.0.0 
> >>release ?
> >>   
> >>
> >
> >That's a known problem. Note that also slowing down are a couple
> >of calls to make it OGC *strict* (force 2d and drop SRID).
> >I think we should speed them up before 1.0.0
> >
> >--strk;
> >
> >For standing up against patentability of software,
> >
> > Thank You, Poland!
> >
> >Read the intervention:    http://kwiki.ffii.org/ConsPolon041221En
> >Send your thanks:         thankyoupoland.info
> >Read/do more:		  http://www.noepatents.org/
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> > 
> >
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

For standing up against patentability of software,

  Thank You, Poland!

Read the intervention:    http://kwiki.ffii.org/ConsPolon041221En
Send your thanks:         thankyoupoland.info
Read/do more:		  http://www.noepatents.org/



More information about the postgis-users mailing list