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.

ASA 7.0 Remote database extraction is getting slower and require db rebuild

7 posts in General Discussion Last posting was on 2003-09-26 14:30:51.0Z
Don Posted on 2003-09-24 18:21:37.0Z
Sender: 7604.3f71e0e2.1804289383@sybase.com
From: Don
Newsgroups: ianywhere.public.general
Subject: ASA 7.0 Remote database extraction is getting slower and require db rebuild
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f71e147.7609.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 24 Sep 2003 11:24:07 -0700, 10.22.241.42
Lines: 7
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 11:17:23 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Sep 2003 11:21:37 -0700
X-Trace: forums-1-dub 1064427697 10.22.108.75 (24 Sep 2003 11:21:37 -0700)
X-Original-Trace: 24 Sep 2003 11:21:37 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1793
Article PK: 4078

Hi all:
I have a 7.0 GB consolidated database upgraded from 5.5.
After upgrade, I have to rebuild the database in two weeks
to have the same remote database 150MB extracted.
After rebuild I can extract in 30 minutes.

NT SP3, ASA 7.0.4 3421


Breck Carter [TeamSybase] Posted on 2003-09-24 19:37:30.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: ASA 7.0 Remote database extraction is getting slower and require db rebuild
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <jmr3nv8gcmk0kffe6lb5b6leiav8pfo4s7@4ax.com>
References: <3f71e147.7609.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 24 Sep 2003 12:37:30 -0700
X-Trace: forums-1-dub 1064432250 64.7.134.118 (24 Sep 2003 12:37:30 -0700)
X-Original-Trace: 24 Sep 2003 12:37:30 -0700, bcarter.sentex.ca
Lines: 32
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1794
Article PK: 4074

Did you *create* the .DB file in Version 7, or just run dbupgrade? To
get performance benefits you must unload, dbinit and reload with
almost *every* SQL Anywhere version upgrade.

Is the disk fragmented? Is the database fragmented? These are two
separate issues, and with old .DB files they can cripple performance.
I call these "Lucy Databases" after the ancient skeleton discovered in
1974 near Hadar in Ethiopia... I'm not saying this *is* your problem,
just asking :)

Is the page size 4K? If not, it probably should be.

Have you considered moving to 8.0.2? Performance on 8 is much better.
Version 7 is very old, not quite as ancient as 5.5, but old
nonetheless. The current version is 9, a wonderful product.

Breck

On 24 Sep 2003 11:21:37 -0700, Don wrote:

>Hi all:
>I have a 7.0 GB consolidated database upgraded from 5.5.
>After upgrade, I have to rebuild the database in two weeks
>to have the same remote database 150MB extracted.
>After rebuild I can extract in 30 minutes.
>
>NT SP3, ASA 7.0.4 3421

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Don Posted on 2003-09-25 12:58:33.0Z
Sender: 351.3f72e3e2.1804289383@sybase.com
From: Don
Newsgroups: ianywhere.public.general
Subject: ASA 7.0 Remote database extraction is getting slower and require db rebuild
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f72e713.399.846930886@sybase.com>
References: <3f71e147.7609.846930886@sybase.com><jmr3nv8gcmk0kffe6lb5b6leiav8pfo4s7@4ax.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 25 Sep 2003 06:01:07 -0700, 10.22.241.42
Lines: 57
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Sep 2003 05:54:15 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Sep 2003 05:58:33 -0700
X-Trace: forums-1-dub 1064494713 10.22.108.75 (25 Sep 2003 05:58:33 -0700)
X-Original-Trace: 25 Sep 2003 05:58:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1795
Article PK: 4079

Thank you very much Breck:

I have rebuild the database in 704 three times 'create,
load..
This is also a rebuild NT server-defraged.
The page size is 4K. I tried 8K, 16K. they gave me similar
performace regarding extraction.

My problem is that the database is running fine under 5.5

I did try to move to 8, The managment said get 7 to work
first.
They know 5.5 works fine. Now I have no teeth to talk to
them about the move.

I have 20 customers 1000 remote users. I need to get this to
work first to get the customers to buy in the move.

Thank you again

Don

> Did you *create* the .DB file in Version 7, or just run
> dbupgrade? To get performance benefits you must unload,
> dbinit and reload with almost *every* SQL Anywhere version
> upgrade.

> Is the disk fragmented? Is the database fragmented? These
> are two separate issues, and with old .DB files they can
> cripple performance. I call these "Lucy Databases" after
> the ancient skeleton discovered in 1974 near Hadar in
> Ethiopia... I'm not saying this *is* your problem, just
> asking :)
>
> Is the page size 4K? If not, it probably should be.
>
> Have you considered moving to 8.0.2? Performance on 8 is
> much better. Version 7 is very old, not quite as ancient
> as 5.5, but old nonetheless. The current version is 9, a
> wonderful product.
>
> Breck
>
> On 24 Sep 2003 11:21:37 -0700, Don wrote:
>
> >Hi all:
> >I have a 7.0 GB consolidated database upgraded from 5.5.
> >After upgrade, I have to rebuild the database in two
> weeks >to have the same remote database 150MB extracted.
> >After rebuild I can extract in 30 minutes.
> >
> >NT SP3, ASA 7.0.4 3421
>
> --
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Breck Carter [TeamSybase] Posted on 2003-09-25 13:20:23.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: ASA 7.0 Remote database extraction is getting slower and require db rebuild
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <3aq5nvsr012g9c90vhtu22veg7tv16t3rt@4ax.com>
References: <3f71e147.7609.846930886@sybase.com><jmr3nv8gcmk0kffe6lb5b6leiav8pfo4s7@4ax.com> <3f72e713.399.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 25 Sep 2003 06:22:57 -0700, bcarter.sentex.ca
Lines: 81
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Sep 2003 06:16:05 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Sep 2003 06:20:23 -0700
X-Trace: forums-1-dub 1064496023 10.22.108.75 (25 Sep 2003 06:20:23 -0700)
X-Original-Trace: 25 Sep 2003 06:20:23 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1796
Article PK: 4076

Is this dbxtract? If memory serves, there are some possibilities for
*very* nasty queries done by the extract, because of the subscribe by
and where clauses. Can you nail down which query or queries are taking
too long?

You can use

dbeng7 -o filespec -zr SQL

to get a request-level-logging report of what the engine is seeing,
and from that determine which query is taking a long time.

Then we can look at the plan for that query. I think the source code
for the queries goes into a file, but again, I am...

Breck With Failing Memory

On 25 Sep 2003 05:58:33 -0700, Don wrote:

>Thank you very much Breck:
>
>I have rebuild the database in 704 three times 'create,
>load..
>This is also a rebuild NT server-defraged.
>The page size is 4K. I tried 8K, 16K. they gave me similar
>performace regarding extraction.
>
>My problem is that the database is running fine under 5.5
>
>I did try to move to 8, The managment said get 7 to work
>first.
>They know 5.5 works fine. Now I have no teeth to talk to
>them about the move.
>
>I have 20 customers 1000 remote users. I need to get this to
>work first to get the customers to buy in the move.
>
>Thank you again
>
>Don
>
>> Did you *create* the .DB file in Version 7, or just run
>> dbupgrade? To get performance benefits you must unload,
>> dbinit and reload with almost *every* SQL Anywhere version
>> upgrade.
>
>> Is the disk fragmented? Is the database fragmented? These
>> are two separate issues, and with old .DB files they can
>> cripple performance. I call these "Lucy Databases" after
>> the ancient skeleton discovered in 1974 near Hadar in
>> Ethiopia... I'm not saying this *is* your problem, just
>> asking :)
>>
>> Is the page size 4K? If not, it probably should be.
>>
>> Have you considered moving to 8.0.2? Performance on 8 is
>> much better. Version 7 is very old, not quite as ancient
>> as 5.5, but old nonetheless. The current version is 9, a
>> wonderful product.
>>
>> Breck
>>
>> On 24 Sep 2003 11:21:37 -0700, Don wrote:
>>
>> >Hi all:
>> >I have a 7.0 GB consolidated database upgraded from 5.5.
>> >After upgrade, I have to rebuild the database in two
>> weeks >to have the same remote database 150MB extracted.
>> >After rebuild I can extract in 30 minutes.
>> >
>> >NT SP3, ASA 7.0.4 3421
>>
>> --
>> bcarter@risingroad.com
>> Mobile and Distributed Enterprise Database Applications
>> www.risingroad.com

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Don Posted on 2003-09-25 14:49:41.0Z
Sender: 1776.3f72f65d.1804289383@sybase.com
From: Don
Newsgroups: ianywhere.public.general
Subject: ASA 7.0 Remote database extraction is getting slower and require db rebuild
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f730085.1878.846930886@sybase.com>
References: <3f71e147.7609.846930886@sybase.com><jmr3nv8gcmk0kffe6lb5b6leiav8pfo4s7@4ax.com> <3f72e713.399.846930886@sybase.com><3aq5nvsr012g9c90vhtu22veg7tv16t3rt@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Sep 2003 07:49:41 -0700
X-Trace: forums-1-dub 1064501381 10.22.241.41 (25 Sep 2003 07:49:41 -0700)
X-Original-Trace: 25 Sep 2003 07:49:41 -0700, 10.22.241.41
Lines: 130
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1797
Article PK: 4081

Thank you Breck , you are the man.

I will try to use your switch to keep the log

In our application, we have build a wraper around the
dbtool. I also build one for dbextract.exe. dbextract is a
little faster, but not much.

The extraction hangs on a 500,000 row table. That table
itself is 500 MB, out of the 7 GB consolidated table.

I have 5 tables like that in the database.

But after rebuilding the consolidated db. It will not hangs
on these tables. It does not hangs on these tables in 5.5.

1 GB memory Dual 500 processor
80 GB RAID

2 GB c:\
78 GB for D:\
page file 1 GB on D:\

Thare are three tables involved in the extraction.

Database_list: keep the list of remote database
and the users - who is using them

Database_episode: Keep the list of the user and the assiged
case number

MCP_PIE_status: Keep the case specific information.


Here is the SUBSCRIBE BY

SUBSCRIBE BY (select c.database_name
from database_2_episode as a,database_list as c
where a.episode_id=MCP_PIE_status.episode_id
and a.clinician_id=c.clinician_id)


Thank you again.

Don

> Is this dbxtract? If memory serves, there are some
> possibilities for *very* nasty queries done by the extract
> , because of the subscribe by and where clauses. Can you
> nail down which query or queries are taking too long?
>
> You can use
>
> dbeng7 -o filespec -zr SQL
>
> to get a request-level-logging report of what the engine
> is seeing, and from that determine which query is taking a
> long time.
>
> Then we can look at the plan for that query. I think the
> source code for the queries goes into a file, but again, I
> am...
>
> Breck With Failing Memory
>
> On 25 Sep 2003 05:58:33 -0700, Don wrote:
>
> >Thank you very much Breck:
> >
> >I have rebuild the database in 704 three times 'create,
> >load..
> >This is also a rebuild NT server-defraged.
> >The page size is 4K. I tried 8K, 16K. they gave me
> similar >performace regarding extraction.
> >
> >My problem is that the database is running fine under 5.5
> >
> >I did try to move to 8, The managment said get 7 to work
> >first.
> >They know 5.5 works fine. Now I have no teeth to talk
> to >them about the move.
> >
> >I have 20 customers 1000 remote users. I need to get this
> to >work first to get the customers to buy in the move.
> >
> >Thank you again
> >
> >Don
> >
> >> Did you *create* the .DB file in Version 7, or just run
> >> dbupgrade? To get performance benefits you must unload,
> >> dbinit and reload with almost *every* SQL Anywhere
> version >> upgrade.
> >
> >> Is the disk fragmented? Is the database fragmented?
> These >> are two separate issues, and with old .DB files
> they can >> cripple performance. I call these "Lucy
> Databases" after >> the ancient skeleton discovered in
> 1974 near Hadar in >> Ethiopia... I'm not saying this *is*
> your problem, just >> asking :)
> >>
> >> Is the page size 4K? If not, it probably should be.
> >>
> >> Have you considered moving to 8.0.2? Performance on 8
> is >> much better. Version 7 is very old, not quite as
> ancient >> as 5.5, but old nonetheless. The current
> version is 9, a >> wonderful product.
> >>
> >> Breck
> >>
> >> On 24 Sep 2003 11:21:37 -0700, Don wrote:
> >>
> >> >Hi all:
> >> >I have a 7.0 GB consolidated database upgraded from
> 5.5. >> >After upgrade, I have to rebuild the database in
> two >> weeks >to have the same remote database 150MB
> extracted. >> >After rebuild I can extract in 30 minutes.
> >> >
> >> >NT SP3, ASA 7.0.4 3421
> >>
> >> --
> >> bcarter@risingroad.com
> >> Mobile and Distributed Enterprise Database Applications
> >> www.risingroad.com
>
> --
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Robert Waywell Posted on 2003-09-26 13:20:58.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3f71e147.7609.846930886@sybase.com><jmr3nv8gcmk0kffe6lb5b6leiav8pfo4s7@4ax.com> <3f72e713.399.846930886@sybase.com><3aq5nvsr012g9c90vhtu22veg7tv16t3rt@4ax.com> <3f730085.1878.846930886@sybase.com>
Subject: Re: ASA 7.0 Remote database extraction is getting slower and require db rebuild
Lines: 160
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: <3f743d3a$1@forums-1-dub>
Date: 26 Sep 2003 06:20:58 -0700
X-Trace: forums-1-dub 1064582458 172.31.142.236 (26 Sep 2003 06:20:58 -0700)
X-Original-Trace: 26 Sep 2003 06:20:58 -0700, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1803
Article PK: 4085

Try running dbxtract -v ... This will show you the exact query being used
during the extract. You can then run that query in dbisql and retrieve the
plan. Comparing the plans between 5.5.x and 7.x will give you an idea of
what the engine is doing differently (if anything). I would also suggest
comparing the performance of the same query in 8.0.2 or 9.0.

--
-----------------------------------------------
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

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

<Don> wrote in message news:3f730085.1878.846930886@sybase.com...
> Thank you Breck , you are the man.
>
> I will try to use your switch to keep the log
>
> In our application, we have build a wraper around the
> dbtool. I also build one for dbextract.exe. dbextract is a
> little faster, but not much.
>
> The extraction hangs on a 500,000 row table. That table
> itself is 500 MB, out of the 7 GB consolidated table.
>
> I have 5 tables like that in the database.
>
> But after rebuilding the consolidated db. It will not hangs
> on these tables. It does not hangs on these tables in 5.5.
>
> 1 GB memory Dual 500 processor
> 80 GB RAID
>
> 2 GB c:\
> 78 GB for D:\
> page file 1 GB on D:\
>
> Thare are three tables involved in the extraction.
>
> Database_list: keep the list of remote database
> and the users - who is using them
>
> Database_episode: Keep the list of the user and the assiged
> case number
>
> MCP_PIE_status: Keep the case specific information.
>
>
> Here is the SUBSCRIBE BY
>
> SUBSCRIBE BY (select c.database_name
> from database_2_episode as a,database_list as c
> where a.episode_id=MCP_PIE_status.episode_id
> and a.clinician_id=c.clinician_id)
>
>
> Thank you again.
>
> Don
>
>
> > Is this dbxtract? If memory serves, there are some
> > possibilities for *very* nasty queries done by the extract
> > , because of the subscribe by and where clauses. Can you
> > nail down which query or queries are taking too long?
> >
> > You can use
> >
> > dbeng7 -o filespec -zr SQL
> >
> > to get a request-level-logging report of what the engine
> > is seeing, and from that determine which query is taking a
> > long time.
> >
> > Then we can look at the plan for that query. I think the
> > source code for the queries goes into a file, but again, I
> > am...
> >
> > Breck With Failing Memory
> >
> > On 25 Sep 2003 05:58:33 -0700, Don wrote:
> >
> > >Thank you very much Breck:
> > >
> > >I have rebuild the database in 704 three times 'create,
> > >load..
> > >This is also a rebuild NT server-defraged.
> > >The page size is 4K. I tried 8K, 16K. they gave me
> > similar >performace regarding extraction.
> > >
> > >My problem is that the database is running fine under 5.5
> > >
> > >I did try to move to 8, The managment said get 7 to work
> > >first.
> > >They know 5.5 works fine. Now I have no teeth to talk
> > to >them about the move.
> > >
> > >I have 20 customers 1000 remote users. I need to get this
> > to >work first to get the customers to buy in the move.
> > >
> > >Thank you again
> > >
> > >Don
> > >
> > >> Did you *create* the .DB file in Version 7, or just run
> > >> dbupgrade? To get performance benefits you must unload,
> > >> dbinit and reload with almost *every* SQL Anywhere
> > version >> upgrade.
> > >
> > >> Is the disk fragmented? Is the database fragmented?
> > These >> are two separate issues, and with old .DB files
> > they can >> cripple performance. I call these "Lucy
> > Databases" after >> the ancient skeleton discovered in
> > 1974 near Hadar in >> Ethiopia... I'm not saying this *is*
> > your problem, just >> asking :)
> > >>
> > >> Is the page size 4K? If not, it probably should be.
> > >>
> > >> Have you considered moving to 8.0.2? Performance on 8
> > is >> much better. Version 7 is very old, not quite as
> > ancient >> as 5.5, but old nonetheless. The current
> > version is 9, a >> wonderful product.
> > >>
> > >> Breck
> > >>
> > >> On 24 Sep 2003 11:21:37 -0700, Don wrote:
> > >>
> > >> >Hi all:
> > >> >I have a 7.0 GB consolidated database upgraded from
> > 5.5. >> >After upgrade, I have to rebuild the database in
> > two >> weeks >to have the same remote database 150MB
> > extracted. >> >After rebuild I can extract in 30 minutes.
> > >> >
> > >> >NT SP3, ASA 7.0.4 3421
> > >>
> > >> --
> > >> bcarter@risingroad.com
> > >> Mobile and Distributed Enterprise Database Applications
> > >> www.risingroad.com
> >
> > --
> > bcarter@risingroad.com
> > Mobile and Distributed Enterprise Database Applications
> > www.risingroad.com


Don Posted on 2003-09-26 14:30:51.0Z
Sender: 161b.3f744d2e.1804289383@sybase.com
From: Don
Newsgroups: ianywhere.public.general
Subject: Thank you Robert I will try to compare 5.5 and 7.04 Re: ASA 7.0 Remote database extraction is getting slower and require db rebuild
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f744e39.162c.846930886@sybase.com>
References: <3f71e147.7609.846930886@sybase.com><jmr3nv8gcmk0kffe6lb5b6leiav8pfo4s7@4ax.com> <3f72e713.399.846930886@sybase.com><3aq5nvsr012g9c90vhtu22veg7tv16t3rt@4ax.com> <3f730085.1878.846930886@sybase.com><3f743d3a$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 26 Sep 2003 07:33:29 -0700, 10.22.241.42
Lines: 167
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Sep 2003 07:26:27 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Sep 2003 07:30:51 -0700
X-Trace: forums-1-dub 1064586651 10.22.108.75 (26 Sep 2003 07:30:51 -0700)
X-Original-Trace: 26 Sep 2003 07:30:51 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1806
Article PK: 17378

Thank you Robert I will try to compare 5.5 and 7.04
Don

> Try running dbxtract -v ... This will show you the exact
> query being used during the extract. You can then run that
> query in dbisql and retrieve the plan. Comparing the plans
> between 5.5.x and 7.x will give you an idea of what the
> engine is doing differently (if anything). I would also
> suggest comparing the performance of the same query in
> 8.0.2 or 9.0.
>
> --
> -----------------------------------------------
> 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
>
> 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
>
> <Don> wrote in message
> > news:3f730085.1878.846930886@sybase.com... Thank you
> Breck , you are the man. >
> > I will try to use your switch to keep the log
> >
> > In our application, we have build a wraper around the
> > dbtool. I also build one for dbextract.exe. dbextract is
> > a little faster, but not much.
> >
> > The extraction hangs on a 500,000 row table. That table
> > itself is 500 MB, out of the 7 GB consolidated table.
> >
> > I have 5 tables like that in the database.
> >
> > But after rebuilding the consolidated db. It will not
> > hangs on these tables. It does not hangs on these tables
> in 5.5. >
> > 1 GB memory Dual 500 processor
> > 80 GB RAID
> >
> > 2 GB c:\
> > 78 GB for D:\
> > page file 1 GB on D:\
> >
> > Thare are three tables involved in the extraction.
> >
> > Database_list: keep the list of remote database
> > and the users - who is using them
> >
> > Database_episode: Keep the list of the user and the
> > assiged case number
> >
> > MCP_PIE_status: Keep the case specific information.
> >
> >
> > Here is the SUBSCRIBE BY
> >
> > SUBSCRIBE BY (select c.database_name
> > from database_2_episode as a,database_list as c
> > where a.episode_id=MCP_PIE_status.episode_id
> > and a.clinician_id=c.clinician_id)
> >
> >
> > Thank you again.
> >
> > Don
> >
> >
> > > Is this dbxtract? If memory serves, there are some
> > > possibilities for *very* nasty queries done by the
> > > extract , because of the subscribe by and where
> > > clauses. Can you nail down which query or queries are
> > taking too long? >
> > > You can use
> > >
> > > dbeng7 -o filespec -zr SQL
> > >
> > > to get a request-level-logging report of what the
> > > engine is seeing, and from that determine which query
> > > is taking a long time.
> > >
> > > Then we can look at the plan for that query. I think
> > > the source code for the queries goes into a file, but
> > > again, I am...
> > >
> > > Breck With Failing Memory
> > >
> > > On 25 Sep 2003 05:58:33 -0700, Don wrote:
> > >
> > > >Thank you very much Breck:
> > > >
> > > >I have rebuild the database in 704 three times
> > > 'create, >load..
> > > >This is also a rebuild NT server-defraged.
> > > >The page size is 4K. I tried 8K, 16K. they gave me
> > > similar >performace regarding extraction.
> > > >
> > > >My problem is that the database is running fine under
> > > 5.5 >
> > > >I did try to move to 8, The managment said get 7 to
> > > work >first.
> > > >They know 5.5 works fine. Now I have no teeth to
> > > talk to >them about the move.
> > > >
> > > >I have 20 customers 1000 remote users. I need to get
> > > this to >work first to get the customers to buy in the
> > > move. >
> > > >Thank you again
> > > >
> > > >Don
> > > >
> > > >> Did you *create* the .DB file in Version 7, or just
> > > run >> dbupgrade? To get performance benefits you must
> > > unload, >> dbinit and reload with almost *every* SQL
> > > Anywhere version >> upgrade.
> > > >
> > > >> Is the disk fragmented? Is the database fragmented?
> > > These >> are two separate issues, and with old .DB
> > > files they can >> cripple performance. I call these
> > > "Lucy Databases" after >> the ancient skeleton
> > > discovered in 1974 near Hadar in >> Ethiopia... I'm
> > > not saying this *is* your problem, just >> asking :)
> > > >>
> > > >> Is the page size 4K? If not, it probably should be.
> > > >>
> > > >> Have you considered moving to 8.0.2? Performance on
> > > 8 is >> much better. Version 7 is very old, not quite
> > > as ancient >> as 5.5, but old nonetheless. The current
> > > version is 9, a >> wonderful product.
> > > >>
> > > >> Breck
> > > >>
> > > >> On 24 Sep 2003 11:21:37 -0700, Don wrote:
> > > >>
> > > >> >Hi all:
> > > >> >I have a 7.0 GB consolidated database upgraded
> > > from 5.5. >> >After upgrade, I have to rebuild the
> > > database in two >> weeks >to have the same remote
> > > database 150MB extracted. >> >After rebuild I can
> > > extract in 30 minutes. >> >
> > > >> >NT SP3, ASA 7.0.4 3421
> > > >>
> > > >> --
> > > >> bcarter@risingroad.com
> > > >> Mobile and Distributed Enterprise Database
> > > Applications >> www.risingroad.com
> > >
> > > --
> > > bcarter@risingroad.com
> > > Mobile and Distributed Enterprise Database
> > > Applications www.risingroad.com
>
>