how to permanently sort records??

[crinoid]

When I add a new record in a db, the record is added at the end of the file, so I sort the database in startup script to get the record in the correct place.

When I reopen the database later, unsorted, the record is still at the end of the file -(

This of course means I have to sort the db each time I open the database. No big consequence when working locally, but when working via WAN for example the sorting takes a g e s ...

How can i renumber or reindex the records permanently once sorted so that they stay in the same position? Can I run a script on shutdown that renumbers or reindexes the records?

[-Queue-]

Look here