Performance issue with some queries on Linux 32 bits [CORE1203]

[firebird-automations]

Submitted by: @kattunga

Attachments:
FBTEST.zip

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

[firebird-automations]

Modified by: @kattunga

Attachment: FBTEST.zip [ 10330 ]

[firebird-automations]

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

[firebird-automations]

Modified by: @kattunga

description: 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 and example could be request at mailto:c_pradelli@yahoo.com.

=>

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 is attached

[firebird-automations]

Modified by: @kattunga

description: 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 is attached

=>

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

[firebird-automations]

Commented by: @AlexPeshkoff

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.

[firebird-automations]

Commented by: @AlexPeshkoff

See my previous comments on an issue, please.

[firebird-automations]

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.2 [ 10130 ]

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 11752 ] => Firebird [ 14718 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test