Bug 1105465

Summary:	Please avoid to create sqlite table index in ibus-table
Product:	[Fedora] Fedora	Reporter:	Peng Wu <pwu>
Component:	ibus-table	Assignee:	Mike FABIAN <mfabian>
Status:	CLOSED ERRATA	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	20	CC:	dchen, i18n-bugs, K9, kent.neo, mfabian, pwu, shawn.p.huang
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	ibus-table-1.8.2-1.fc20	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-06-12 06:25:44 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.