Issue Details (XML | Word | Printable)

Key: CORE-1203
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Christian Pradelli
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Performance issue with some queries on Linux 32 bits

Created: 11/Apr/07 10:41 AM   Updated: 16/Jun/07 10:32 AM
Component/s: None
Affects Version/s: 2.0.1
Fix Version/s: 2.0.2

Time Tracking:
Not Specified

File Attachments: 1. Zip Archive FBTEST.zip (3.15 MB)

Environment: Firebird SS 2.0.1 on Linux NPTL 32 bits


 Description  « Hide
Some queries takes 100% more time in FB2.0.1 Linux 32 bits compared with FB1.5.x.
There is more information in developer forum under "PLAN Optimization problem in FB 2.0.1" thread.
A test database with query example is attached

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 10/May/07 03:24 AM
Christian!
After backporting of Vlad's speed fix for sparse bitmaps, I see 15% difference between fb 1.5 and 2.0 (gcc 3.4.6, amd64, both in 32-bit mode optimized for this CPU). But fb2.0 consumes 25-30 times less memory compared with 1.5. This all is predictable - used in 2.0 Btree instead of hash table to represent sparse bitmap works in some cases a bit slower, but always requires _much_ less memory.

I suggest to close this issue as fixed in 2.0.2.

Alexander Peshkov added a comment - 21/May/07 06:32 PM
See my previous comments on an issue, please.