Subject Re: [firebird-support] Restoring Backup
Author Dimitry Sibiryakov
24.02.2016 20:37, Ann Harrison aharrison@... [firebird-support] wrote:
> When it is restoring data, it
> fills a data page and goes on to the next one. A large cache will fill with
> pages that will not be referenced again until the indexes are built. To
> build indexes, Firebird reads records and sorts by keys. That might
> suggest that keeping millions of pages in cache would improve performance
> by eliminating disk reads.

Putting restored data to data pages and sorting streams at the same time also could
eliminate reads.