in reply to Append to a busy flat-file db without leaving customer in lurch

You could try creating muliple flat files.

When a request arrives, you only open and lock one of the flat database files, either in a random manner, or by some deterministic way (such as the first letter of the customer). Of course, you then have to modify the programs reading the files to read all of them.

  • Comment on Re: Append to a busy flat-file db without leaving customer in lurch