Re: [SAGE] simple database problem

[Jon maddog Hall <maddog@li.org>]

Andrew,

A little more information would be helpful:

Is this machine dedicated to the database (I have a feeling it is not, since
the buffer cache seems to be trashed by other "things" running)?

> performance is significantly helped by simply running 'wc db.dbm'

How much real memory does this machine have?  Could you sustain the entire
database in real memory while also running these other programs?  mlock(2)
might fix your problems.

> apparently because of the random seeking around in the database file.

I assume that you have the sources to the database, so you could make changes
to it.  Is it easy to read the database serially, tossing away records
that are not active, rather than randomly, for your "print all"?

Thanks,

maddog
-- 
Jon "maddog" Hall
Executive Director           Linux International(R)
email: maddog@li.org         80 Amherst St. 
Voice: +1.603.672.4557       Amherst, N.H. 03031-3032 U.S.A.
WWW: http://www.li.org

Board Member: Uniforum Association, USENIX Association

(R)Linux is a registered trademark of Linus Torvalds in several countries.
(R)Linux International is a registered trademark in the USA used pursuant
   to a license from Linux Mark Institute, authorized licensor of Linus
   Torvalds, owner of the Linux trademark on a worldwide basis
(R)UNIX is a registered trademark of The Open Group in the USA and other
   countries.