/ Timeline

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Parents and children of check-in [43c59c85]

Improvements to the way the query planner handles sorting costs, so that very large sorting costs do not overwhelm the loop costs. check-in: bdaa6947 user: drh tags: trunk
Fix a buffer overrun in the previous commit. Closed-Leaf check-in: 43c59c85 user: dan tags: query-planner-fix
Because SQLite internally calculates query plan costs using a logarithmic scale, very large estimated sorting costs can cause all other estimated costs to be rounded down to zero. In these cases break ties between plans with the same total cost by comparing the costs with sorting excluded. This is an alternative fix for the problem addressed by [2af630c572]. check-in: 299b9570 user: dan tags: query-planner-fix