| 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 | |