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.

Sybase central slow to display tables

2 posts in General Discussion Last posting was on 2011-02-02 05:50:03.0Z
PDreyer Posted on 2011-02-01 13:05:00.0Z
Sender: 23b2.4d47c263.1804289383@sybase.com
From: PDreyer
Newsgroups: sybase.public.ase.general
Subject: Sybase central slow to display tables
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d4804fc.3165.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: 1 Feb 2011 05:05:00 -0800
X-Trace: forums-1-dub 1296565500 10.22.241.41 (1 Feb 2011 05:05:00 -0800)
X-Original-Trace: 1 Feb 2011 05:05:00 -0800, 10.22.241.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29910
Article PK: 79140

Sybase Central appear to hang for around 2 minutes every now
and again
Sybase Central 6.0.0.4727
ASE 15.0.3

At that time a
select * from master..monProcessSQLText

indicate it is doing:

select table_name=O.name, owner_name=U.name,
creation_date=O.crdate, table_object_id=O.id, sysstat2
, table_object_type='U', remote_object='',
remote_object_type='table'
, row_count(23, O.id)
, reserved_pages(23, O.id)
, data_pages(23, O.id)
, data_pages(23, O.id, 0)
from mx_docc.dbo.sysobjects O, mx_docc.dbo.sysusers U
where O.uid = U.uid
and O.type = 'U'
and sysstat2 & 1024 != 1024
and U.name like '%'
and O.name like '%'
order by 1

Is there a way to tel Sybase central not to display table
size/rowcount info
There is almost ten thousand tables in the database

If I test the query without the row_count() and ...pages()
functions the elapsed time is half a second
Put the functions back and…
Adaptive Server elapsed time: 106396 ms.


Regards
PDreyer


Cory Sane [TeamSybase] Posted on 2011-02-02 05:50:03.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4d4804fc.3165.1681692777@sybase.com>
In-Reply-To: <4d4804fc.3165.1681692777@sybase.com>
Subject: Re: Sybase central slow to display tables
Lines: 13
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18263
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d48f08b$1@forums-1-dub>
Date: 1 Feb 2011 21:50:03 -0800
X-Trace: forums-1-dub 1296625803 10.22.241.152 (1 Feb 2011 21:50:03 -0800)
X-Original-Trace: 1 Feb 2011 21:50:03 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29911
Article PK: 79139

I have a few databases with 1000's of objects... many client graphical apps (3rd party) hang when loading the table list.
You may be able to build a name cache for your system tables to prevent the physical io of calculating these values.


sysobjects
sysindexes
syspartitions
syscolumns???
--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0