Subject | Re: [Firebird-Architect] Re: Some benchmarks about 'Order by' - temporary indexes?... |
---|---|
Author | Ann W. Harrison |
Post date | 2006-09-22T15:00:14Z |
Vlad Horsun wrote:
it avoids re-reading the records in sorted order which is much slower.
We should only be carrying the fields that were requested, so the
size of the record doesn't matter, only the number and size of the
fields in the select list.
Regards,
Ann
>Are you sure that's a weakness? True it makes sorting slower, but
> This is known weak of our sorting algoritm. In-memory we do move
> of pointers but on disk we move whole records. You can learn sort.cpp
> to be sure
it avoids re-reading the records in sorted order which is much slower.
We should only be carrying the fields that were requested, so the
size of the record doesn't matter, only the number and size of the
fields in the select list.
Regards,
Ann