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.

Performance difference between chained and unchained mode

2 posts in General Discussion Last posting was on 2010-01-11 08:16:07.0Z
Ray Posted on 2010-01-11 07:48:02.0Z
From: "Ray" <lcm@hotmail.com>
Newsgroups: sybase.public.ase.general
Subject: Performance difference between chained and unchained mode
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4ad7b2@forums-1-dub>
Date: 10 Jan 2010 23:48:02 -0800
X-Trace: forums-1-dub 1263196082 10.22.241.152 (10 Jan 2010 23:48:02 -0800)
X-Original-Trace: 10 Jan 2010 23:48:02 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28862
Article PK: 78103

Hi,

I found that Stored Procedure can be created in chained, unchained amd any
mode.

Does anyone know if the performance impact would be induced when using any
of the modes?

Thanks,
Raymond


Rob V [ Sybase ] Posted on 2010-01-11 08:16:07.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <4b4ad7b2@forums-1-dub>
Subject: Re: Performance difference between chained and unchained mode
Lines: 42
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4ade47$1@forums-1-dub>
Date: 11 Jan 2010 00:16:07 -0800
X-Trace: forums-1-dub 1263197767 10.22.241.152 (11 Jan 2010 00:16:07 -0800)
X-Original-Trace: 11 Jan 2010 00:16:07 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28863
Article PK: 78105

There is no performance aspect as such. Chained or unchained mode are just
different models of transaction handling (more correctly, of starting a
transaction).
What matters here is what your application expects: when using chained mode,
applications typically issue a commit after every SQL command (including
selects) to close the implicitly just-opened transaction. This is not needed
in unchained mode since transactions will only be started explicitly.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"Ray" <lcm@hotmail.com> wrote in message news:4b4ad7b2@forums-1-dub...
> Hi,
>
> I found that Stored Procedure can be created in chained, unchained amd any
> mode.
>
> Does anyone know if the performance impact would be induced when using any
> of the modes?
>
> Thanks,
> Raymond
>