Bug 1105465 - Please avoid to create sqlite table index in ibus-table
Summary: Please avoid to create sqlite table index in ibus-table
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: ibus-table
Version: 20
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Mike FABIAN
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-06-06 08:10 UTC by Peng Wu
Modified: 2014-06-12 06:30 UTC (History)
7 users (show)

Fixed In Version: ibus-table-1.8.2-1.fc20
Clone Of:
Environment:
Last Closed: 2014-06-12 06:25:44 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Peng Wu 2014-06-06 08:10:13 UTC
In the past ibus-tables create some sqlite table index to speed up lookup.

Since ibus-table 1.8.1, the table schema has been changed, and the sqlite file size is reduced.

As ibus-table uses SQL "LIKE" clause now, table index is not used when matching.

By remove all table index, the wubi-jidian86.db has shrinked from 12M to 5.7M.
Smaller file size will also improve the speed, as it can be loaded into memory.

Maybe we can skip some sqlite table index creations, to reduce file sizes.

BTW, Thanks very much for the improvements of ibus-table 1.8.1!

Comment 1 Mike FABIAN 2014-06-06 09:11:07 UTC
https://github.com/kaio/ibus-table/pull/39

Comment 2 Mike FABIAN 2014-06-07 04:10:46 UTC
Merged upstream.

Comment 3 Fedora Update System 2014-06-09 06:09:35 UTC
ibus-table-1.8.2-1.fc19 has been submitted as an update for Fedora 19.
https://admin.fedoraproject.org/updates/ibus-table-1.8.2-1.fc19

Comment 4 Fedora Update System 2014-06-09 06:10:19 UTC
ibus-table-1.8.2-1.fc20 has been submitted as an update for Fedora 20.
https://admin.fedoraproject.org/updates/ibus-table-1.8.2-1.fc20

Comment 5 Fedora Update System 2014-06-10 02:52:13 UTC
Package ibus-table-1.8.2-1.fc20:
* should fix your issue,
* was pushed to the Fedora 20 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing ibus-table-1.8.2-1.fc20'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2014-7110/ibus-table-1.8.2-1.fc20
then log in and leave karma (feedback).

Comment 6 Fedora Update System 2014-06-12 06:25:44 UTC
ibus-table-1.8.2-1.fc19 has been pushed to the Fedora 19 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 7 Fedora Update System 2014-06-12 06:30:07 UTC
ibus-table-1.8.2-1.fc20 has been pushed to the Fedora 20 stable repository.  If problems still persist, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.