Sorting records are larger than really necessary
------------------------------------------------
Key: CORE-4353
URL: http://tracker.firebirdsql.org/browse/CORE-4353
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1, 2.5.2 Update 1, 2.1.5 Update 1,
2.5.2, 2.1.5, 2.5.1, 2.1.4, 2.5.0, 2.1.3, 2.1.2, 2.1.1, 2.1.0
Reporter: Dmitry Yemanov
Priority: Minor
In external sorting (SORT plan), every record being sorted is stored as the
sort key plus all the referenced fields plus stream-level information plus
padding/alignment. However, the sorting record length is calculated
inaccurately, causing redundant bytes to be allocated but never used. This
causes the sort blocks to grow more than necessary thus slowing down the
operation, especially when number of records being sorted is huge and sort
blocks are swapped to disk. In most practical cases, this overhead is
relatively small and is unlikely to be more than 5-10%, but in some artificial
cases it could be up to 50%.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
