Dimitry, > IIRC, sorting in Firebird has three phases: > > 1) Quick sort in memory buffer > 2) Write sorted buffer to temp file > 3) Merge sort of data from temp files > > Do anybody know how much time in percent of total sort time is spent to > each phase?
There is no one answer to that question. It depends on the size of the dataset being returned and the number of sorting levels (size of the sort key) which are applied. Sean ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
