Database size (my old story)
Posted: Tue Jul 13, 2010 5:01 am
Hi Alex
I say my old words about size of database in SQLite
version: 1.2p1
file: http://rapidshare.com/files/406649732/cintanotes.db
1) I add some notes
2) I set tags for its
3) I RENAME tag 444 to other name,
4) I rename other name to 444
5) I do it several times
See attachment file:
If you EXPORT TO XML this file, after this DELETE database.file, open CN & IMPORT XML, filesize will be 26kB. Now it is 40 kb
Maybe todo features - 'optimize database size': auto-export in XML, delete, auto-import XML
But, It isn't critical. I think
Best regards.
I say my old words about size of database in SQLite
version: 1.2p1
file: http://rapidshare.com/files/406649732/cintanotes.db
1) I add some notes
2) I set tags for its
3) I RENAME tag 444 to other name,
4) I rename other name to 444
5) I do it several times
See attachment file:
If you EXPORT TO XML this file, after this DELETE database.file, open CN & IMPORT XML, filesize will be 26kB. Now it is 40 kb
Maybe todo features - 'optimize database size': auto-export in XML, delete, auto-import XML
But, It isn't critical. I think
Best regards.