Forum Post
Index > Scribe > SQLite

Author/Date SQLite
ALL
13/12/2010 7:44pm
Last versions of InScribe use SQLite database for mailstorage.

I think you can make 'optimize mail-database' function. f.ex. -vacuum or some other way.
I know it is a big problem for SQLite database: 'Vacuum' - it isn't so good way.

How do you do it now in last version of InScribe?
ALL
14/12/2010 4:06am
f.ex.
I open mail2 and convert its to mail3
after this, I delete ALL mails and clear Trash and compress db.
Db's size = 90% from original (full=2100kB) size = 1900kB !!! for clear( empty database) !!!

I use mail2 database and have no any problem
fret
14/12/2010 7:27am
Two things:
1) You can compact the mail3 with the vacuum command from inside the manage mail stores dialog, using the "Compact" button.
2) In normal use the sqlite database reuses free space within the file, so if you are constantly deleting and adding things what ends up happening is the mail3 file stays the same size. However a mail2 only ever appends to the end of the file, even if there is free space within the middle of the file. This causes it to grow larger until such a time as the user compacts the mail store. For most people that don't run tests ;) this means the mail3 is better. Because it stays smaller for longer. But there is still the capability to compact it if needed.
ALL
14/12/2010 7:15pm
I say:
I 'Compact' my database several times. Its size is 1900kB. All mail was deleted.
My it's a bug SQLite.
ALL
14/12/2010 7:41pm
Now I think It is bug of InScribe:
http://d.imagehost.org/0316/2010-12-14_103410.png

See image:
I convert mail2 to mail3. I delete all mails. I clear Trash.
I optimize database. I have 2MB for empty database.

I delete folders with mails.
I think InScribe can optimize only deleted mails in some folder. (not deleted folders with mails)
fret
21/12/2010 2:05pm
That optimize button is not what I was talking about (it should be removed, it's no longer relevant). I mean rather from the Main Menu -> File -> Manage Mail Stores -> [select mail3] -> Compact Mail Store.
ALL
21/12/2010 6:50pm
> That optimize button is not what I was talking about

I know You think that all are morons

I try this way and I try that way I try any way

http://img810.imageshack.us/img810/9965/20101221.png

My ask is:

Why number of folder is 22 ??? (as original file has, but I delete all folders)

Try to think.

I know answer: InScribe deletes only mails
and
doesn't delete folder in folder of mails

Best regards...
fret
21/12/2010 9:55pm
Ok I don't have time to research all the issues you raised in your post right now, but I'll look at it when I get a chance over the christmas new year break.
ALL
21/12/2010 11:05pm
Thanks.

Happy New Year !
Reply