Too many buffers a bad thing??

jozef

New Member
G'day. Openedge 10.2A, Redhat Linux, 12GB memory, 4k blocks

We're running multiple servers, multiple dbs / server. None of the db's are very large.

One server we have 2 db's - 1 around 2.5Gb, the other around 700mb.

Is there an issue if I set the -B value to some large figure? E.g. for the 2.5Gb db I've got:


Total buffers: 900002
Hash table size: 270029
Used buffers: 661669
Empty buffers: 238333
All the servers are doing is running the 2 db's - no other apps will be using the memory.

Cheers
 
As long as you have sufficient memory to support the values that you use there is no downside. The upside starts to vanish though as -B approaches the size of the db...
 
Thanks Tom.

Why does the upside start to vanish? I would have thought that having a -B > db size would permit every added record to remain in memory? Or have I misunderstood?
 
Sure, that's the ideal. It's just that your return on investment is related to the square root of the increase in -B and it eventually becomes zero once the db does, in fact, fit in memory.

If your db is small enough to fit in an affordable amount of memory go for it.

Even if it is too large to fit the more you put in -B the better. Just not quite as much better as you go.
 
Hi Tom.

Thanks for the reply. Don't know where I've been for the last couples of weeks but it certainly wasn't here :lol:
 
Back
Top