Gossamer Forum
Home : Products : DBMan : Discussions :

Sorting the .db file

Quote Reply
Sorting the .db file
Is there any problem with sorting the .db file at the OS level? I'm referring to setting up a cron job that would sort a file like this:

sort /path/events.db > /path/events.db.sorted
mv /path/events.db.sorted /path/events.db

Will this mess up any pointers or indexes that DBMan might be using? Assume sorting is done during off hours with no contention for database.
Quote Reply
Re: [acravens] Sorting the .db file In reply to
As long as you keep each record completely intact, changing the order of the records won't make any difference at all. There are no pointers or indexes in the regular DBMan.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.