I would guess that Xiaowu Gai's problem is with disk access. Everything is
very fast while filling up cache, but when the kernel's object cache gets
full objects need writing to disk (which they all will eventually) and if
the disk connection is not good then this will slow things way down. This
type of behaviour would be typical of any database.
> From xgai at iastate.edu Mon Apr 17 10:56:30 2000
> Subject: Please help
>> I need your help. Our database, ZmDB, is an ACEDB database. I found an
> interesting problem with ACEDB that confuses and frustrates me. When I used
> the Ace parser to load a large .ace file, it first was flying (relatively)
> and parsed thousands of records in a few minutes. However, after a while ,
> it seemed reach to a critical point where it becomes terribly slow (about
> one record per minute). I am very frustrated and puzzled. I can not find
> anywhere in ACEDB documents that says anything about it? Can you shed some
> lights on it? Thank you.