[postgis-users] Insert performance issues

[Obe, Regina DND\MIS]

You said you have all the fields indexed involved in the query.  Exactly how
many fields do you have indexed?

-----Original Message-----
From: Nicolas RIBOT [mailto:nri at scot.cnes.fr]
Sent: Monday, October 20, 2003 10:38 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Insert performance issues


> Are you running the query set in a transaction block?
> 
Yes, I think so:
I set the connection to be rolled-back by doing, in VB, a
Connection.BeginTrans

Then I write all SQL commands in a text file.
At the end, when all commands are written, I execute this file within
VBA.
If no errors occur, I commit the transaction at the end.

I do not explicitly write a "begin... end" in my SQL file, as it is done
with shp2pgsql, for example.
Should I ?

Would it be quicker to prepare the statements and to bind parameters ?

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users