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
I have a PL/PGSQL stored procedure on my server which is about 3,500 lines
long. To further improve performance after more than year of optimizing the
PL/PGSQL, and also to hide the logic so it is not as easy to copy, I am
starting to re-write the stored procedure in C. The initial design is such
t
