Subject Re: [Firebird-Architect] Re: Some benchmarks about 'Order by' - temporary
Author Arno Brinkman
Hi Ann,

> Err, actually, Jim and I just talked about the way sort works,
> and unless something has changed, nothing is "moved around on
> disk". When a sort run is larger than the memory allowed, it
> is written out in sorted order. When all records have been
> sorted, the runs are merged. If that's right, then runs are
> both read and written sequentially, which seems like the best
> of both worlds... given that you've got a world where the
> sorted set doesn't fit in memory.

When does the merging (of multiple runs) happen? [By fetch, on first execute, ..?]
Is the final merge only in memory or also written to disk?

Arno Brinkman

General database development support:

Firebird open source database (based on IB-OE) with many SQL-99 features :

Support list for Firebird and Interbase users :

Nederlandse firebird nieuwsgroep :