Index - Contents - Home

Sorting Databases

Scid has a fast and powerful Sort Database feature. Sorts can be performed on single fields (eg: Dates, Names and ECO codes), or multiple fields, with the first field having priority, and so-on.

The available criteria/fields are

Sorting is Permanent

When you sort a database which is not read-only, the results are saved immediately and the order of games is permanently changed. If this is not desired, one may first make the database read-only from the maintenance window, or sort the games in the clipbase.

When sorting a read-only database (or PGN archive) , the results cannot be saved and the order of games is lost when the file is closed.

Database Performance

When a database is sorted the Index File is altered but the Game File is not (leaving the game file records out of order relative to the Index File). This can result in slow tree, position and material/pattern searches. After sorting, one should reorder the game file by compacting it to maintain good search performance.

Additionaly, only databases sorted by ECO codes (and subsequently compacted) can use fast tree searches.

Updated: Scid vs. PC 4.10 August 2013