Enterprise Library Caching performance is slow once cache database contains about 6000 rows

Topics: Caching Application Block
Sep 17, 2009 at 3:37 PM

Hi there,

I am using Enterprise Library 2.0. We are using Enterprise Library database caching, and it works ok until the cache table reaches about 6000 rows. Then everything slows down, and cpu reaches about 80%. However if we clear the cache then it goes back to normal and performance is ok.

Any idea of why the caching will slow down so badly with only 6000 rows in the caching table.

Thanks

N

Sep 18, 2009 at 8:53 AM

Hi,

What is the value of your maximumElementsInCacheBeforeScavenging?

Valiant Dudan
Global Technology and Solutions
Avanade, Inc.

entlib.support@avanade.com

Sep 18, 2009 at 12:38 PM

HI,

It is set to 50000..

We store objects in the cache, can it be related? As other tables that store simple fields but much much bigger than the cache table work ok.

Thanks

N