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.

DB ASA 7.0.04 is very very slow

3 posts in General Discussion Last posting was on 2004-03-05 10:38:17.0Z
NGUYEN Posted on 2004-03-03 10:20:40.0Z
Reply-To: "NGUYEN" <phang.n@free.fr>
From: "NGUYEN" <phang.n@free.fr>
Newsgroups: ianywhere.public.general
Subject: DB ASA 7.0.04 is very very slow
Lines: 15
Organization: LB2 CONCEPT
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: amontsouris-108-1-3-185.w193-251.abo.wanadoo.fr
Message-ID: <4045b19f@forums-2-dub>
X-Original-Trace: 3 Mar 2004 02:21:19 -0800, amontsouris-108-1-3-185.w193-251.abo.wanadoo.fr
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Mar 2004 02:19:22 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Mar 2004 02:20:40 -0800
X-Trace: forums-1-dub 1078309240 10.22.108.75 (3 Mar 2004 02:20:40 -0800)
X-Original-Trace: 3 Mar 2004 02:20:40 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2696
Article PK: 6171

Hello all,

My DB ASA 7.0.04 is very very slow when I execute the SQL SELECT and the
stored procedure.

I have checked the index and the primary key in the tables of data base, but
I don't obtain bester result.

I NEED YOUR HELP !

Thank you before !

Phang NGUYEN


Robert Waywell Posted on 2004-03-03 15:35:02.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4045b19f@forums-2-dub>
Subject: Re: DB ASA 7.0.04 is very very slow
Lines: 56
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: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <4045fb26$1@forums-1-dub>
Date: 3 Mar 2004 07:35:02 -0800
X-Trace: forums-1-dub 1078328102 172.31.142.236 (3 Mar 2004 07:35:02 -0800)
X-Original-Trace: 3 Mar 2004 07:35:02 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2700
Article PK: 6172

What is slow?
How long does it take?
What are you comparing this to?
What is the query?
What are the table definitions?
What does the plan show?
How many records in each of the tables?
Are you using User Defined Functions?
Have you compared the current performance to the same query against a
rebuilt database using the 9.0 Developer Edition?
Would you like to be contacted by our Professional Services organization?



--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"NGUYEN" <phang.n@free.fr> wrote in message news:4045b19f@forums-2-dub...
> Hello all,
>
> My DB ASA 7.0.04 is very very slow when I execute the SQL SELECT and the
> stored procedure.
>
> I have checked the index and the primary key in the tables of data base,
but
> I don't obtain bester result.
>
> I NEED YOUR HELP !
>
> Thank you before !
>
> Phang NGUYEN
>
>


NGUYEN Posted on 2004-03-05 10:38:17.0Z
Reply-To: "NGUYEN" <phang.n@free.fr>
From: "NGUYEN" <phang.n@free.fr>
Newsgroups: ianywhere.public.general
References: <4045b19f@forums-2-dub> <4045fb26$1@forums-1-dub>
Subject: Re: DB ASA 7.0.04 is very very slow
Lines: 76
Organization: LB2 CONCEPT
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: amontsouris-108-1-22-50.w80-14.abo.wanadoo.fr
Message-ID: <404858c9$1@forums-2-dub>
X-Original-Trace: 5 Mar 2004 02:39:05 -0800, amontsouris-108-1-22-50.w80-14.abo.wanadoo.fr
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Mar 2004 02:36:48 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Mar 2004 02:38:17 -0800
X-Trace: forums-1-dub 1078483097 10.22.108.75 (5 Mar 2004 02:38:17 -0800)
X-Original-Trace: 5 Mar 2004 02:38:17 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2718
Article PK: 6191

Thank for your answer, I resolve this problem, finally this problem caused
by the migration ASA 6.xx to ASA 7.0.04
I have deleted the olds index in the tables (of version 6) and its recreate
after te migration in version 7. Now it takes 5 min for executing.

Thank you very much
NGUYEN

"Robert Waywell" <nospam_rwaywell@ianywhere.com> a écrit dans le message de
news:4045fb26$1@forums-1-dub...

> What is slow?
I execute the stored procedure
> How long does it take?
more than 2 hours
> What are you comparing this to?
with PowerBuilder , build 10227
> What is the query?
> What are the table definitions?
> What does the plan show?
> How many records in each of the tables?
55000 lines
> Are you using User Defined Functions?
> Have you compared the current performance to the same query against a
> rebuilt database using the 9.0 Developer Edition?
NON
> Would you like to be contacted by our Professional Services organization?
Yes
>
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> ug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "NGUYEN" <phang.n@free.fr> wrote in message news:4045b19f@forums-2-dub...
> > Hello all,
> >
> > My DB ASA 7.0.04 is very very slow when I execute the SQL SELECT and the
> > stored procedure.
> >
> > I have checked the index and the primary key in the tables of data base,
> but
> > I don't obtain bester result.
> >
> > I NEED YOUR HELP !
> >
> > Thank you before !
> >
> > Phang NGUYEN
> >
> >
>
>