Re: C on Client versus C on Server - Mailing list pgsql-performance

On 02.04.2011 21:52, Eliot Gable wrote:
> 1) Each select statement from the User Client C Module would be a separate
> transaction which would drastically increase transaction overhead for the
> whole set of requests.

You could wrap the statements in BEGIN-COMMIT in the client code.

> 2) Writing the billing data at the end would mean that I not only have to
> pull all the data down to the User Client, I must also push the data back up
> to the server for writing the billing records.

Yeah, that sounds right.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com