[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Varnamproject-discuss] [bug #40714] [libvarnam] Update patterns content
|
From: |
Kevin Martin Jose |
|
Subject: |
[Varnamproject-discuss] [bug #40714] [libvarnam] Update patterns content and see if WITHOUT_ROWID is helpful |
|
Date: |
Thu, 20 Mar 2014 20:22:44 +0000 |
|
User-agent: |
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0 |
Follow-up Comment #1, bug #40714 (project varnamproject):
I have used sqlite_analyzer on ml.vst.learnings before and after using
'without rowid' on patterns_content. There is a significant improvement in
storage size. The db used to be about 500 mb after learning the word corpus.
'without rowid' shrinked it to 294mb! See the attachments. withoutrowid.txt
specifies the stats after using 'without rowid' on patterns_content.
(file #30975, file #30976)
_______________________________________________________
Additional Item Attachment:
File name: withoutrowid.txt Size:20 KB
File name: withrowid.txt Size:25 KB
_______________________________________________________
Reply to this item at:
<http://savannah.nongnu.org/bugs/?40714>
_______________________________________________
Message sent via/by Savannah
http://savannah.nongnu.org/
- [Varnamproject-discuss] [bug #40714] [libvarnam] Update patterns content and see if WITHOUT_ROWID is helpful,
Kevin Martin Jose <=