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.

Workspace take a long time to display stored procedures in the treeview

2 posts in General Discussion Last posting was on 2006-08-17 09:32:05.0Z
Laurent Posted on 2006-08-03 16:48:10.0Z
Sender: 6821.44d223a5.1804289383@sybase.com
From: Laurent
Newsgroups: sybase.public.workspace.general
Subject: Workspace take a long time to display stored procedures in the treeview
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44d228ca.6850.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Aug 2006 09:48:10 -0700
X-Trace: forums-1-dub 1154623690 10.22.241.41 (3 Aug 2006 09:48:10 -0700)
X-Original-Trace: 3 Aug 2006 09:48:10 -0700, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:133
Article PK: 1087780

Hello,

I'm currently evaluating the database part of workspace 1.5
with ASE 12.5.3 on a HPUX server.

When I display stored procedures list in database explorer
treeview,
it's very long 5 to 10 minutes.

I have around 3000 sp in the databases and I'm alone on the
server.

My computer has got 512Mo of ram (380 used with WS
runningà, but is not working during the delay. It's only
working when Workspace displayes the treeview.

Are there parameters I could check to fast the treeview
display ?

Best regards,
Laurent

PS : it's not a network problem.


Laurent Posted on 2006-08-17 09:32:05.0Z
Sender: 5155.44e432aa.1804289383@sybase.com
From: Laurent
Newsgroups: sybase.public.workspace.general
Subject: Re: Workspace take a long time to display stored procedures in the treeview
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44e4353f.51b3.1681692777@sybase.com>
References: <44d228ca.6850.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 17 Aug 2006 02:22:07 -0700, 10.22.241.42
Lines: 7
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2006 02:22:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2006 02:32:05 -0700
X-Trace: forums-1-dub 1155807125 10.22.108.75 (17 Aug 2006 02:32:05 -0700)
X-Original-Trace: 17 Aug 2006 02:32:05 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:147
Article PK: 1087792

Hello,

I had contact with Sybase rep, who send me a internal build
of WS.
It helps, now it takes 2 min ... but it still too long :(

Laurent