Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Cost of disconnect

7 posts in Objects Last posting was on 2003-01-03 13:14:37.0Z
Goya Posted on 2002-12-30 02:59:06.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: Goya
Date: Sun, 29 Dec 2002 21:59:06 -0500
Subject: Cost of disconnect
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <364_9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.powerbuilder.objects:667
Article PK: 713239

In my application, I am using "disconnect using TransactionObject", and I
found the time required is quite long it normally takes over 1 seconds to
disconnect from DB whereas the connection time required for the same
TransactionObject is about 0.12 second only. Is there any thing I can do to
improve the disconnect performance.


Chris Pollach Posted on 2003-01-02 14:04:55.0Z
Newsgroups: sybase.public.powerbuilder.objects
Reply-To: "Chris Pollach" <cpollach@ajja.com>
From: "Chris Pollach" <cpollach@ajja.com>
Subject: Re: Cost of disconnect
Date: Thu, 2 Jan 2003 09:04:55 -0500
Lines: 23
Organization: STD Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: listserv.scc-csc.gc.ca 209.47.227.131
Message-ID: <364_Y92PXpmsCHA.161@forums.sybase.com>
References: <364_9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:661
Article PK: 713227

I am surprised on the Disconnect over-head. Usually the Connect is where
you pay heavily. In general, most client-server applications do not do
pseudo-conversational programming (which is what you seem to be doing -
Connecting/Disconnecting all the time between transactions). The popular
design mode for C/S applications is conversational mode where the
application remains connected to the DBMS while the application is active.
To minimize the DB connection over-head, you can use the Idle ( ) timer
to catch a period of inactivity, and then do the disconnect until the user
reactivates the application. Then reissue the Connect.

regards ... Chris
Great White North Technical Evangelist

<Goya> wrote in message
news:9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums...
> In my application, I am using "disconnect using TransactionObject", and I
> found the time required is quite long it normally takes over 1 seconds to
> disconnect from DB whereas the connection time required for the same
> TransactionObject is about 0.12 second only. Is there any thing I can do
to
> improve the disconnect performance.


Bruce Armstrong [TeamSybase] Posted on 2003-01-02 14:51:57.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Subject: Re: Cost of disconnect
Date: Thu, 02 Jan 2003 06:51:57 -0800
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 63
NNTP-Posting-Host: 66-214-149-29.az-eres.charterpipeline.net 66.214.149.29
Message-ID: <364_ebk81vs31807qam0fep66scpfl7f2l2okm@4ax.com>
References: <364_9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums> <364_Y92PXpmsCHA.161@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:660
Article PK: 713229

Chris,

PMFJI

The problem I've been having with that approach is that any
datawindows/datastores that were opened when the disconnect happened
now have an invalid transaction object. I reconnect the transaction,
but unless I reissue the SetTransObject call, I'll get a dberror on
the next database attemp. Short of (a) using SetTrans rather than
SetTransObject, or (b) creating a process that loops through all
datawindows/datastores in memory and reperforms the SetTransObject or
(c) adding something to your framework that implements the
SetTransObject before every database call, have you found a way to
handle this?

On Thu, 2 Jan 2003 09:04:55 -0500, "Chris Pollach" <cpollach@ajja.com>

wrote:

> I am surprised on the Disconnect over-head. Usually the Connect is where
>you pay heavily. In general, most client-server applications do not do
>pseudo-conversational programming (which is what you seem to be doing -
>Connecting/Disconnecting all the time between transactions). The popular
>design mode for C/S applications is conversational mode where the
>application remains connected to the DBMS while the application is active.
> To minimize the DB connection over-head, you can use the Idle ( ) timer
>to catch a period of inactivity, and then do the disconnect until the user
>reactivates the application. Then reissue the Connect.
>
>regards ... Chris
>Great White North Technical Evangelist
>
><Goya> wrote in message
>news:9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums...
>> In my application, I am using "disconnect using TransactionObject", and I
>> found the time required is quite long it normally takes over 1 seconds to
>> disconnect from DB whereas the connection time required for the same
>> TransactionObject is about 0.12 second only. Is there any thing I can do
>to
>> improve the disconnect performance.
>

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

Not 1 - but 2 new books on developing with PowerBuilder
http://www.pb9books.com

Which can now be pre-ordered through Amazon.com
http://www.amazon.com/exec/obidos/tg/detail/-/0672325004
http://www.amazon.com/exec/obidos/tg/detail/-/0672324997

If you would like to continue to be able to use Google to search *all* of these newsgroups, please contact Google at and let them know.
mailto:groups-support@google.com

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org


Chris Pollach Posted on 2003-01-02 15:31:00.0Z
Newsgroups: sybase.public.powerbuilder.objects
Reply-To: "Chris Pollach" <cpollach@ajja.com>
From: "Chris Pollach" <cpollach@ajja.com>
Subject: Re: Cost of disconnect
Date: Thu, 2 Jan 2003 10:31:00 -0500
Lines: 95
Organization: STD Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: listserv.scc-csc.gc.ca 209.47.227.131
Message-ID: <364_KAmvdZnsCHA.161@forums.sybase.com>
References: <364_9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums> <364_Y92PXpmsCHA.161@forums.sybase.com> <364_ebk81vs31807qam0fep66scpfl7f2l2okm@4ax.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:659
Article PK: 713226

Bruce;

Here is what I do......

1) Create a Standard Class User Object from Transaction. Add a variable
to indicate DB connected. Instantiate this as SQLCA.
2) Add to the object from Step #1 two methods (i.e.: of_connect( ) and
of_disconnect ( )). In these methods, set the "DB Connect " flag
appropriately after a Connect or DisConnect SQL call. (Tip: You can also
check the DBHandle ( ) pointer).
3) Add a method to the object in step #1, (i.e.: of_Check_db ( DC) and
pass in your DW Control ref. pointer).
4) Overload the method from Step #2 to handle Data Stores.
5) In the "Check DB" main method logic, if the "DB Connected" flag is
FALSE, issue a real SQL Connect and SetTransObject (DS/DC Pointer ) method
call.
6) Before performing any Retrieve ( ) on a concrete level DS or DW
control, issue the call " SQLCA.of_Check_DB (THIS) ".
7) On the Idle Timer event of the Application, issue the
SQLCA.of_DisConnect ( ) method call.

Works great for me! Hope that helps.

regards ... Chris
Great White North Technical Evangelist

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>

wrote in message news:ebk81vs31807qam0fep66scpfl7f2l2okm@4ax.com...
> Chris,
>
> PMFJI
>
> The problem I've been having with that approach is that any
> datawindows/datastores that were opened when the disconnect happened
> now have an invalid transaction object. I reconnect the transaction,
> but unless I reissue the SetTransObject call, I'll get a dberror on
> the next database attemp. Short of (a) using SetTrans rather than
> SetTransObject, or (b) creating a process that loops through all
> datawindows/datastores in memory and reperforms the SetTransObject or
> (c) adding something to your framework that implements the
> SetTransObject before every database call, have you found a way to
> handle this?
>
> On Thu, 2 Jan 2003 09:04:55 -0500, "Chris Pollach" <cpollach@ajja.com>
> wrote:
>
> > I am surprised on the Disconnect over-head. Usually the Connect is
where
> >you pay heavily. In general, most client-server applications do not do
> >pseudo-conversational programming (which is what you seem to be doing -
> >Connecting/Disconnecting all the time between transactions). The popular
> >design mode for C/S applications is conversational mode where the
> >application remains connected to the DBMS while the application is
active.
> > To minimize the DB connection over-head, you can use the Idle ( )
timer
> >to catch a period of inactivity, and then do the disconnect until the
user
> >reactivates the application. Then reissue the Connect.
> >
> >regards ... Chris
> >Great White North Technical Evangelist
> >
> ><Goya> wrote in message
> >news:9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums...
> >> In my application, I am using "disconnect using TransactionObject", and
I
> >> found the time required is quite long it normally takes over 1 seconds
to
> >> disconnect from DB whereas the connection time required for the same
> >> TransactionObject is about 0.12 second only. Is there any thing I can
do
> >to
> >> improve the disconnect performance.
> >
>
> Bruce Armstrong [TeamSybase]
> http://www.teamsybase.com
>
> Not 1 - but 2 new books on developing with PowerBuilder
> http://www.pb9books.com
>
> Which can now be pre-ordered through Amazon.com
> http://www.amazon.com/exec/obidos/tg/detail/-/0672325004
> http://www.amazon.com/exec/obidos/tg/detail/-/0672324997
>
> If you would like to continue to be able to use Google to search *all* of
these newsgroups, please contact Google at and let them know.
> mailto:groups-support@google.com
>
> Preach the gospel at all times. If necessary, use words. - Francis of
Assisi
> http://www.needhim.org


Bruce Armstrong [TeamSybase] Posted on 2003-01-03 04:15:38.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Subject: Re: Cost of disconnect
Date: Thu, 02 Jan 2003 20:15:38 -0800
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 133
NNTP-Posting-Host: 66-214-149-29.az-eres.charterpipeline.net 66.214.149.29
Message-ID: <364_r63a1vga6fb1135jdp4eb91hpkrqiru0mr@4ax.com>
References: <364_9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums> <364_Y92PXpmsCHA.161@forums.sybase.com> <364_ebk81vs31807qam0fep66scpfl7f2l2okm@4ax.com> <364_KAmvdZnsCHA.161@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:655
Article PK: 713223

Well, yes, but unfortunately I'm looking at trying to retrofit this to
an existing PFC based application. The issue is trying to get the
SetTransObject redone before any Retrieve or Update call, and that
might involve a bit of work in overriding PFC itself, which I don't
want to do.

The last time I did this was back before datastores were introduced
and I simply looped through the control array of any open windows
looking for datawindows and made the call after the app was
reactivated (and the connection re-established). I'm now beginning to
think that ti might just involve something similar, but I'm going to
have to check every object in memory for objects of type datastore....

On Thu, 2 Jan 2003 10:31:00 -0500, "Chris Pollach" <cpollach@ajja.com>

wrote:

>Bruce;
>
> Here is what I do......
>
>1) Create a Standard Class User Object from Transaction. Add a variable
>to indicate DB connected. Instantiate this as SQLCA.
>2) Add to the object from Step #1 two methods (i.e.: of_connect( ) and
>of_disconnect ( )). In these methods, set the "DB Connect " flag
>appropriately after a Connect or DisConnect SQL call. (Tip: You can also
>check the DBHandle ( ) pointer).
>3) Add a method to the object in step #1, (i.e.: of_Check_db ( DC) and
>pass in your DW Control ref. pointer).
>4) Overload the method from Step #2 to handle Data Stores.
>5) In the "Check DB" main method logic, if the "DB Connected" flag is
>FALSE, issue a real SQL Connect and SetTransObject (DS/DC Pointer ) method
>call.
>6) Before performing any Retrieve ( ) on a concrete level DS or DW
>control, issue the call " SQLCA.of_Check_DB (THIS) ".
>7) On the Idle Timer event of the Application, issue the
>SQLCA.of_DisConnect ( ) method call.
>
>Works great for me! Hope that helps.
>
>regards ... Chris
>Great White North Technical Evangelist
>
>"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
>wrote in message news:ebk81vs31807qam0fep66scpfl7f2l2okm@4ax.com...
>> Chris,
>>
>> PMFJI
>>
>> The problem I've been having with that approach is that any
>> datawindows/datastores that were opened when the disconnect happened
>> now have an invalid transaction object. I reconnect the transaction,
>> but unless I reissue the SetTransObject call, I'll get a dberror on
>> the next database attemp. Short of (a) using SetTrans rather than
>> SetTransObject, or (b) creating a process that loops through all
>> datawindows/datastores in memory and reperforms the SetTransObject or
>> (c) adding something to your framework that implements the
>> SetTransObject before every database call, have you found a way to
>> handle this?
>>
>> On Thu, 2 Jan 2003 09:04:55 -0500, "Chris Pollach" <cpollach@ajja.com>
>> wrote:
>>
>> > I am surprised on the Disconnect over-head. Usually the Connect is
>where
>> >you pay heavily. In general, most client-server applications do not do
>> >pseudo-conversational programming (which is what you seem to be doing -
>> >Connecting/Disconnecting all the time between transactions). The popular
>> >design mode for C/S applications is conversational mode where the
>> >application remains connected to the DBMS while the application is
>active.
>> > To minimize the DB connection over-head, you can use the Idle ( )
>timer
>> >to catch a period of inactivity, and then do the disconnect until the
>user
>> >reactivates the application. Then reissue the Connect.
>> >
>> >regards ... Chris
>> >Great White North Technical Evangelist
>> >
>> ><Goya> wrote in message
>> >news:9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums...
>> >> In my application, I am using "disconnect using TransactionObject", and
>I
>> >> found the time required is quite long it normally takes over 1 seconds
>to
>> >> disconnect from DB whereas the connection time required for the same
>> >> TransactionObject is about 0.12 second only. Is there any thing I can
>do
>> >to
>> >> improve the disconnect performance.
>> >
>>
>> Bruce Armstrong [TeamSybase]
>> http://www.teamsybase.com
>>
>> Not 1 - but 2 new books on developing with PowerBuilder
>> http://www.pb9books.com
>>
>> Which can now be pre-ordered through Amazon.com
>> http://www.amazon.com/exec/obidos/tg/detail/-/0672325004
>> http://www.amazon.com/exec/obidos/tg/detail/-/0672324997
>>
>> If you would like to continue to be able to use Google to search *all* of
>these newsgroups, please contact Google at and let them know.
>> mailto:groups-support@google.com
>>
>> Preach the gospel at all times. If necessary, use words. - Francis of
>Assisi
>> http://www.needhim.org
>

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

Not 1 - but 2 new books on developing with PowerBuilder
http://www.pb9books.com

Which can now be pre-ordered through Amazon.com
http://www.amazon.com/exec/obidos/tg/detail/-/0672325004
http://www.amazon.com/exec/obidos/tg/detail/-/0672324997

If you would like to continue to be able to use Google to search *all* of these newsgroups, please contact Google at and let them know.
mailto:groups-support@google.com

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org


Chris Pollach Posted on 2003-01-03 13:14:37.0Z
Newsgroups: sybase.public.powerbuilder.objects
Reply-To: "Chris Pollach" <cpollach@ajja.com>
From: "Chris Pollach" <cpollach@ajja.com>
Subject: Re: Cost of disconnect
Date: Fri, 3 Jan 2003 08:14:37 -0500
Lines: 151
Organization: STD Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 209.47.227.134
Message-ID: <364_$b7u7xysCHA.161@forums.sybase.com>
References: <364_9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums> <364_Y92PXpmsCHA.161@forums.sybase.com> <364_ebk81vs31807qam0fep66scpfl7f2l2okm@4ax.com> <364_KAmvdZnsCHA.161@forums.sybase.com> <364_r63a1vga6fb1135jdp4eb91hpkrqiru0mr@4ax.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:654
Article PK: 713221

Bruce;

Just did one conversion this past Spring. It only took a about a week.
Works great in production now for over 6 months!
Note: the PFC architecture easily lends itself to this type of retrofit.

Best of luck.

regards ... Chris
Great White North Technical Evangelist

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>

wrote in message news:r63a1vga6fb1135jdp4eb91hpkrqiru0mr@4ax.com...
> Well, yes, but unfortunately I'm looking at trying to retrofit this to
> an existing PFC based application. The issue is trying to get the
> SetTransObject redone before any Retrieve or Update call, and that
> might involve a bit of work in overriding PFC itself, which I don't
> want to do.
>
> The last time I did this was back before datastores were introduced
> and I simply looped through the control array of any open windows
> looking for datawindows and made the call after the app was
> reactivated (and the connection re-established). I'm now beginning to
> think that ti might just involve something similar, but I'm going to
> have to check every object in memory for objects of type datastore....
>
> On Thu, 2 Jan 2003 10:31:00 -0500, "Chris Pollach" <cpollach@ajja.com>
> wrote:
>
> >Bruce;
> >
> > Here is what I do......
> >
> >1) Create a Standard Class User Object from Transaction. Add a
variable
> >to indicate DB connected. Instantiate this as SQLCA.
> >2) Add to the object from Step #1 two methods (i.e.: of_connect( ) and
> >of_disconnect ( )). In these methods, set the "DB Connect " flag
> >appropriately after a Connect or DisConnect SQL call. (Tip: You can also
> >check the DBHandle ( ) pointer).
> >3) Add a method to the object in step #1, (i.e.: of_Check_db ( DC) and
> >pass in your DW Control ref. pointer).
> >4) Overload the method from Step #2 to handle Data Stores.
> >5) In the "Check DB" main method logic, if the "DB Connected" flag is
> >FALSE, issue a real SQL Connect and SetTransObject (DS/DC Pointer )
method
> >call.
> >6) Before performing any Retrieve ( ) on a concrete level DS or DW
> >control, issue the call " SQLCA.of_Check_DB (THIS) ".
> >7) On the Idle Timer event of the Application, issue the
> >SQLCA.of_DisConnect ( ) method call.
> >
> >Works great for me! Hope that helps.
> >
> >regards ... Chris
> >Great White North Technical Evangelist
> >
> >"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
> >wrote in message news:ebk81vs31807qam0fep66scpfl7f2l2okm@4ax.com...
> >> Chris,
> >>
> >> PMFJI
> >>
> >> The problem I've been having with that approach is that any
> >> datawindows/datastores that were opened when the disconnect happened
> >> now have an invalid transaction object. I reconnect the transaction,
> >> but unless I reissue the SetTransObject call, I'll get a dberror on
> >> the next database attemp. Short of (a) using SetTrans rather than
> >> SetTransObject, or (b) creating a process that loops through all
> >> datawindows/datastores in memory and reperforms the SetTransObject or
> >> (c) adding something to your framework that implements the
> >> SetTransObject before every database call, have you found a way to
> >> handle this?
> >>
> >> On Thu, 2 Jan 2003 09:04:55 -0500, "Chris Pollach" <cpollach@ajja.com>
> >> wrote:
> >>
> >> > I am surprised on the Disconnect over-head. Usually the Connect is
> >where
> >> >you pay heavily. In general, most client-server applications do not do
> >> >pseudo-conversational programming (which is what you seem to be
doing -
> >> >Connecting/Disconnecting all the time between transactions). The
popular
> >> >design mode for C/S applications is conversational mode where the
> >> >application remains connected to the DBMS while the application is
> >active.
> >> > To minimize the DB connection over-head, you can use the Idle ( )
> >timer
> >> >to catch a period of inactivity, and then do the disconnect until the
> >user
> >> >reactivates the application. Then reissue the Connect.
> >> >
> >> >regards ... Chris
> >> >Great White North Technical Evangelist
> >> >
> >> ><Goya> wrote in message
> >> >news:9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums...
> >> >> In my application, I am using "disconnect using TransactionObject",
and
> >I
> >> >> found the time required is quite long it normally takes over 1
seconds
> >to
> >> >> disconnect from DB whereas the connection time required for the same
> >> >> TransactionObject is about 0.12 second only. Is there any thing I
can
> >do
> >> >to
> >> >> improve the disconnect performance.
> >> >
> >>
> >> Bruce Armstrong [TeamSybase]
> >> http://www.teamsybase.com
> >>
> >> Not 1 - but 2 new books on developing with PowerBuilder
> >> http://www.pb9books.com
> >>
> >> Which can now be pre-ordered through Amazon.com
> >> http://www.amazon.com/exec/obidos/tg/detail/-/0672325004
> >> http://www.amazon.com/exec/obidos/tg/detail/-/0672324997
> >>
> >> If you would like to continue to be able to use Google to search *all*
of
> >these newsgroups, please contact Google at and let them know.
> >> mailto:groups-support@google.com
> >>
> >> Preach the gospel at all times. If necessary, use words. - Francis of
> >Assisi
> >> http://www.needhim.org
> >
>
> Bruce Armstrong [TeamSybase]
> http://www.teamsybase.com
>
> Not 1 - but 2 new books on developing with PowerBuilder
> http://www.pb9books.com
>
> Which can now be pre-ordered through Amazon.com
> http://www.amazon.com/exec/obidos/tg/detail/-/0672325004
> http://www.amazon.com/exec/obidos/tg/detail/-/0672324997
>
> If you would like to continue to be able to use Google to search *all* of
these newsgroups, please contact Google at and let them know.
> mailto:groups-support@google.com
>
> Preach the gospel at all times. If necessary, use words. - Francis of
Assisi
> http://www.needhim.org


"John Olson [Team Sybase]" <john.olson Posted on 2002-12-30 21:48:57.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Subject: Re: Cost of disconnect
Date: Mon, 30 Dec 2002 16:48:57 -0500
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: tom.scn.spawar.navy.mil 192.171.8.14
Message-ID: <364_k#EYr$EsCHA.161@forums.sybase.com>
References: <364_9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:664
Article PK: 713233

I don't know of any. Most likely the time is consumed by your db upon
disconnect request. Maybe it's cleaning up something. Are you doing a
commit/rollback before you disconnect? If not, PB would be executing one of
those before disconnecting. Be sure to handle your own transaction
management. Try tracing your SQL and see if the disconnect request to the db
is in fact eating up that much time.

Finally, if you can't solve it and can't live with the time problem consider
reusing your connections.

Regards,
John
Team Sybase

<Goya> wrote in message
news:9D15FC0902472449001065B385256C9F.001065C285256C9F@webforums...
> In my application, I am using "disconnect using TransactionObject", and I
> found the time required is quite long it normally takes over 1 seconds to
> disconnect from DB whereas the connection time required for the same
> TransactionObject is about 0.12 second only. Is there any thing I can do
to
> improve the disconnect performance.