[Fedora-i18n-bugs] [Bug 1105465] New: Please avoid to create sqlite table index in ibus-table
by Red Hat Bugzilla
https://bugzilla.redhat.com/show_bug.cgi?id=1105465
Bug ID: 1105465
Summary: Please avoid to create sqlite table index in
ibus-table
Product: Fedora
Version: 20
Component: ibus-table
Assignee: mfabian(a)redhat.com
Reporter: pwu(a)redhat.com
QA Contact: extras-qa(a)fedoraproject.org
CC: dchen(a)redhat.com, i18n-bugs(a)lists.fedoraproject.org,
kent.neo(a)gmail.com, me(a)kaio.net, mfabian(a)redhat.com,
pwu(a)redhat.com, shawn.p.huang(a)gmail.com
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!
--
You are receiving this mail because:
You are on the CC list for the bug.
Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=tf19HHJyHi&a=cc_unsubscribe
9 years, 11 months