Re: C on Client versus C on Server

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: C on Client versus C on Server
Дата
Msg-id 4D981B65.8030209@enterprisedb.com
обсуждение исходный текст
Ответ на C on Client versus C on Server  (Eliot Gable <egable+pgsql-performance@gmail.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Eliot Gable
Дата:
Сообщение: C on Client versus C on Server
Следующее
От: Lars Feistner
Дата:
Сообщение: Re: very long updates very small tables