[Fedora-i18n-bugs] [Bug 1105465] New: Please avoid to create sqlite table index in ibus-table

[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

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465

Mike FABIAN <mfabian(a)redhat.com&gt; changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED



-- 
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=sy1I7FoI9n&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465



--- Comment #1 from Mike FABIAN <mfabian(a)redhat.com&gt; ---
https://github.com/kaio/ibus-table/pull/39

-- 
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=qUKmiTsyk7&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465



--- Comment #2 from Mike FABIAN <mfabian(a)redhat.com&gt; ---
Merged upstream.

-- 
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=BH3tj6CYxT&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465

Fedora Update System <updates(a)fedoraproject.org&gt; changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |MODIFIED



-- 
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=zWxLRLGboj&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465



--- Comment #3 from Fedora Update System <updates(a)fedoraproject.org&gt; ---
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

-- 
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=YIk2kyY6hO&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465



--- Comment #4 from Fedora Update System <updates(a)fedoraproject.org&gt; ---
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

-- 
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=OpuGqm2UBw&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465

Fedora Update System <updates(a)fedoraproject.org&gt; changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|MODIFIED                    |ON_QA



--- Comment #5 from Fedora Update System <updates(a)fedoraproject.org&gt; ---
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...
then log in and leave karma (feedback).

-- 
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=W59vAjVzuu&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465

Fedora Update System <updates(a)fedoraproject.org&gt; changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ON_QA                       |CLOSED
   Fixed In Version|                            |ibus-table-1.8.2-1.fc19
         Resolution|---                         |ERRATA
        Last Closed|                            |2014-06-12 02:25:44



--- Comment #6 from Fedora Update System <updates(a)fedoraproject.org&gt; ---
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.

-- 
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=mwRuy07lG3&a=cc_unsubscribe

[Fedora-i18n-bugs] [Bug 1105465] Please avoid to create sqlite table index in ibus-table

[Red Hat Bugzilla]

https://bugzilla.redhat.com/show_bug.cgi?id=1105465

Fedora Update System <updates(a)fedoraproject.org&gt; changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Fixed In Version|ibus-table-1.8.2-1.fc19     |ibus-table-1.8.2-1.fc20



--- Comment #7 from Fedora Update System <updates(a)fedoraproject.org&gt; ---
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.

-- 
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=fnLcUWemyM&a=cc_unsubscribe