[postgis-users] Fast access to PostGIS from c/c++

[Mark Cave-Ayland]

On Wed, 2006-12-06 at 10:48 +0100, Boehm, Andreas wrote:
> Hi Mark,
> 
> thanks for your advice.
> 
> > If all your geometries are of one type, e.g. points, the 
> > second fastest method would probably be to use a prepared 
> > statement using the MakePoint() function [...]
> Using libpqxx prepared functionality with MakePoint() works fine.
> Unfortunately is slower than inserting with GeometryFromText().

Hi Andi,

*blinks* really?

Can you post your test cases for both MakePoint() and
GeometryFromText()? Over how many points are you testing? There are
several reasons why this shouldn't happen, including that all
GeometryFromText() input has to go through a bison-generated parser
which is not the case with MakePoint()...


Kind regards,

Mark.