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.

Get low speed in Procedure.

3 posts in General Discussion Last posting was on 2004-02-24 14:48:45.0Z
Chandresh Patel Posted on 2004-02-24 06:05:43.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: Get low speed in Procedure.
Lines: 125
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: aca14b2c.ipt.aol.com
X-Original-NNTP-Posting-Host: aca14b2c.ipt.aol.com
Message-ID: <403ae9b7@forums-1-dub>
Date: 23 Feb 2004 22:05:43 -0800
X-Trace: forums-1-dub 1077602743 172.161.75.44 (23 Feb 2004 22:05:43 -0800)
X-Original-Trace: 23 Feb 2004 22:05:43 -0800, aca14b2c.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2605
Article PK: 5743

Hi,

make few call to network server I wrote one procedure and now it takes long
time rather then reguler.

I post my all 3 question in .txt file which is attached with this message.

Help me to resolve this problem.


Thanks in Advance.


Chris Keating (iAnywhere Solutions) Posted on 2004-02-24 13:50:08.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <403ae9b7@forums-1-dub>
Subject: Re: Get low speed in Procedure.
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <403b569d$1@forums-2-dub>
X-Original-Trace: 24 Feb 2004 05:50:21 -0800, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Feb 2004 05:49:37 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Feb 2004 05:50:08 -0800
X-Trace: forums-1-dub 1077630608 10.22.108.75 (24 Feb 2004 05:50:08 -0800)
X-Original-Trace: 24 Feb 2004 05:50:08 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2608
Article PK: 5747

please post each question in a separate thread.

Also, please note that this newsgroup is monitored by the user community.
People who participate in responding to your questions are doing so on a
volunteer basis. So, it is in your best interest to faciliate by not
expecting people to read a long document in the form of an attachment.
Please refrain from including attachments unless asked.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:403ae9b7@forums-1-dub...
> Hi,
>
> make few call to network server I wrote one procedure and now it takes
long
> time rather then reguler.
>
> I post my all 3 question in .txt file which is attached with this message.
>
> Help me to resolve this problem.
>
>
> Thanks in Advance.
>
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-02-24 14:48:45.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <403ae9b7@forums-1-dub> <403b569d$1@forums-2-dub>
Subject: Re: Get low speed in Procedure.
Lines: 93
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <403b645c$1@forums-2-dub>
X-Original-Trace: 24 Feb 2004 06:49:00 -0800, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Feb 2004 06:48:16 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Feb 2004 06:48:45 -0800
X-Trace: forums-1-dub 1077634125 10.22.108.75 (24 Feb 2004 06:48:45 -0800)
X-Original-Trace: 24 Feb 2004 06:48:45 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2610
Article PK: 5748

BTW

Run tests with the procedure profiler to identify the bottleneck.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>

wrote in message news:403b569d$1@forums-2-dub...
> please post each question in a separate thread.
>
> Also, please note that this newsgroup is monitored by the user community.
> People who participate in responding to your questions are doing so on a
> volunteer basis. So, it is in your best interest to faciliate by not
> expecting people to read a long document in the form of an attachment.
> Please refrain from including attachments unless asked.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
>
****************************************************************************
> *
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
> *
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
>
****************************************************************************
> *
>
> "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> news:403ae9b7@forums-1-dub...
> > Hi,
> >
> > make few call to network server I wrote one procedure and now it takes
> long
> > time rather then reguler.
> >
> > I post my all 3 question in .txt file which is attached with this
message.
> >
> > Help me to resolve this problem.
> >
> >
> > Thanks in Advance.
> >
> >
> >
>
>