OpenEuphoria

RE: EDS Database indexing?

• Posted by Bernie Ryan <xotron at localnet.com> Jun 05, 2001
• 341 views

Euman wrote:
> Hello all,
> 
> I need to make some changes to an EDS database
> and need some advise.
> 
> Lets take an example:
> If I have 8000 records and a user decides to delete record # 6999
> should I leave the key alone and nullify the record space

  I would suggest the following.
  If the record #'s were a double-linked-list stored in memory then
  all you have to do is move pointers when you delete a record. Then
  when the file is closed this list would be written with the data
  to the file. A Utility program or routine would be executed by the
  user to clean the file at his option ( making a backup as it
  runs ). Even if the record list gets destroyed in memory the
  record's data is still there and can be recovered.

Bernie