Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Caching
Wed, Oct 3 2007 9:58 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

How about a switch to say cache the whole table - to be used responsibly of course. I'm mainly thinking of smallish lookup tables in a fileserver scenario so I don't have to figure out how big they might be but would like them fully in ram.

Roy Lambert
Wed, Oct 3 2007 10:22 AMPermanent Link

Dave Harrison
Roy Lambert wrote:
> How about a switch to say cache the whole table - to be used responsibly of course. I'm mainly thinking of smallish lookup tables in a fileserver scenario so I don't have to figure out how big they might be but would like them fully in ram.
>
> Roy Lambert

Roy,
    Are you referring to EDB or DBISAM? What happens when you have two
users one who want 500MB for the table cache and the other who wants
only 25k? I think that's why EDB insists on putting the buffers in the
table definition.

Dave
Wed, Oct 3 2007 10:44 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Dave

> Are you referring to EDB or DBISAM?

ElevateDB

>What happens when you have two
>users one who want 500MB for the table cache and the other who wants
>only 25k? I think that's why EDB insists on putting the buffers in the
>table definition.

That's why I said fileserver Smiley

Roy Lambert


Thu, Oct 4 2007 11:26 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< How about a switch to say cache the whole table - to be used responsibly
of course. I'm mainly thinking of smallish lookup tables in a fileserver
scenario so I don't have to figure out how big they might be but would like
them fully in ram. >>

Just simply make the buffer sizes for the table(s) larger than the estimated
max size of the table.  That will ensure that they are always buffered
entirely in memory.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image