On Aug 13, 2007, at 11:54 PM, Lim Berger wrote:
> I am testing through PHP microtime function. The query is administered
> through pg_query() function of PHP. I know there could be some latency
> coming in from the PHP's PG functions' overhead, but not such an order
> of magnitude different from "mysqli_query"! (I hope -- because this
> is quite a common real-world situation I would think).
You might also try using prepared statements for your inserts (see
PHP's pg_prepare and pg_execute functions). This will also save time
you are likely using to escape the inserted strings.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL