Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - 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.

Processor Cache

2 posts in Windows NT Last posting was on 2000-05-20 06:11:58.0Z
Weiss Christian Posted on 2000-05-19 07:31:19.0Z
From: "Weiss Christian" <>
Subject: Processor Cache
Date: Fri, 19 May 2000 09:31:19 +0200
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <E4tlhTWw$>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!!
Xref: forums-1-dub sybase.public.sqlserver.nt:2149
Article PK: 1089581


how important is the size of the level two cache of the cpu for the
speed of the database.

Because we have to choose between 512k up to 2 M

Thanks for support

Christian Weiß, wellcom international

"Mark A. Parsons" <pegasys Posted on 2000-05-20 06:11:58.0Z
Message-ID: <>
Date: Sat, 20 May 2000 18:11:58 +1200
From: "Mark A. Parsons" <>
Organization: Pegasys (2000) Limited
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Processor Cache
References: <E4tlhTWw$>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 32
Path: forums-1-dub!!
Xref: forums-1-dub sybase.public.sqlserver.nt:2145
Article PK: 1089577

> how important is the size of the level two cache of the cpu for the
> speed of the database.

No offense ... but I don't think this is a database specific issue. In
other words ... forgetting about databases for the minute and just
focusing on the cpu itself ... what does a larger level two cache do for
the cpu? Will this allow the cpu to spend more time processing vs.
waiting for 'slower' memory accesses?

If a level two cache will improve cpu performance then, generally,
anything that uses the cpu should see an improvement. And since Sybase
dataservers use their fair share of cpu cycles ... well ... there should
definitely be some improvements.

Now, will *you* see an improvement? *shrug* It would depend on your
environment. For example, if you have a disk I/O intensive application
then a few less cpu cycles may not be too noticeable ... especially in
light of the *SLOW* speeds of a disk (when compared to cpu speeds).

How to know for sure? Test it? Get specs from the chip (set) maker?
In other words, what kind of raw cpu speed 'improvements' can you expect
to get between the 512K and 2M cache's?

Mark A. Parsons

Iron Horse, Inc.
Pegasys (200), Ltd