Closed
Bug 895038
Opened 12 years ago
Closed 12 years ago
consider increasing gloda sqlite page size, i.e. bigger than 1k
Categories
(MailNews Core :: Database, defect)
Tracking
(blocking-thunderbird3.1 beta2+, thunderbird3.1 beta2-fixed)
RESOLVED
WORKSFORME
| Tracking | Status | |
|---|---|---|
| blocking-thunderbird3.1 | --- | beta2+ |
| thunderbird3.1 | --- | beta2-fixed |
People
(Reporter: wsmwk, Unassigned)
Details
(Keywords: perf)
+++ This bug was initially created as a clone of Bug #539389 +++
wada's bug 539389 comment 97 and Asuth's response comment 100:
> > Am I better to open separate bug(s) for hard-to-understand-why I/O behaviour on
> > journal of SQLite DB and for looks-inefficient I/O behavior on SQLite DB(looks
> > to use 1KB buffer which I think too small)?
> [Neil] SQLite is actually an imported library so any issues would have to go upstream.
The 1k writes are because gloda uses a 1k page size; that can be changed. A new bug should be logged in 'MailNews / Database' if the suggestions is to increase the size.
|
||
Comment 1•12 years ago
|
||
Gloda currently uses the default page size of mozStorage which is 32k
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → WORKSFORME
|
|
||
Comment 2•12 years ago
|
||
er, and if you want to manually verify, what you want to do is open up the db in sqlite and run "pragma page_size;"
Here's the linux command-line to type and the output
$ sqlite3 global-messages-db.sqlite "pragma page_size;"
32768
You need to log in
before you can comment on or make changes to this bug.
Description
•