U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Patch: Reconnecting PostgreSQL Automatically on Unstable Networks

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks [message #26411 is a reply to message #26402]

Fri, 30 April 2010 10:53

mirek is currently offline

mirek
Messages: 13976
Registered: November 2005

Ultimate Member

zsolt wrote on Thu, 29 April 2010 19:41

I don't use DECLARE CURSOR and FECTH SQL statements, only simple SELECTS.

If you iterate on the result of a SELECT, it iterates on a table in RAM, AFAIK, so reconnection is not an issue here.

Ah, I mean U++ Fetch. Am not using cursors and FETCH either.

Well, you are right that in this PGSQL version, the result set is in RAM. It can change in future though...

(Frankly, I was quite surprised by this issue - sometimes I am loading quite big result sets a pgsql allocating 0.5G is no fun... Smile

Smile

Quote:

BTW, I changed PostgreSQLSession::Rollback() to:

void PostgreSQLSession::Rollback()
{
	ExecTrans("rollback");
	if(level>0) level--;
}

and my app is quite usable now on unstable networks.

I guess this patch cannot cause any harm -> applied.

Mirek

Report message to a moderator

Send a private message to this user

[Message index]

		Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Tue, 27 April 2010 19:21
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Tue, 27 April 2010 20:21
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Tue, 27 April 2010 21:19
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Wed, 28 April 2010 14:31
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Thu, 29 April 2010 23:55
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Fri, 30 April 2010 01:41
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Fri, 30 April 2010 10:53
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Tue, 04 May 2010 12:11
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Mon, 17 May 2010 14:47
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Mon, 17 May 2010 15:44

Previous Topic:	Any way to generate sch from database?
Next Topic:	SQLITE3: Bind parameter by name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun May 12 08:01:08 CEST 2024

Total time taken to generate the page: 0.02057 seconds