Jump to content
Bobby12345

Rebuilt database size

Recommended Posts

Hi, 

For several years now, whenever I have rebuilt my database from the servers I have noticed rather large file size discrepancies between the larger old (now backup) database and the new database. I haven't really noticed any data loss, but with databases of such size, going back so many years, it would be difficult to tell.

I have raised tickets, asked questions etc before without ever really receiving a clear answer beyond vague talk of 'streamlining'. Now, once again I have rebuilt my database, and the old database stands at 11.5GB, with the new one at 3.1GB. Same laptop, I haven't used on-demand sync. Is it really plausible that these two databases essentially contain the same content? 

Many thanks

Share this post


Link to post

It's plausible to me. Evernote for Windows is built on a SQLite database. You might try searching the web for something 'sqlite database rebuild size'. I found this article that might be helpful: https://sqlite.org/lang_vacuum.html

Share this post


Link to post
4 hours ago, jefito said:

It's plausible to me. Evernote for Windows is built on a SQLite database. You might try searching the web for something 'sqlite database rebuild size'. I found this article that might be helpful: https://sqlite.org/lang_vacuum.html

Because of this inherent issue, 'intelligent' applications have the rebuild option included.

Share this post


Link to post
2 hours ago, JohnLongney said:

Because of this inherent issue, 'intelligent' applications have the rebuild option included.

And Evernote already does, but as a hidden (but not secret) support option, so I guess they count as 'intelligent', whatever that was meant to imply.

Anyways, Ctrl+click on the Help menu item, and you'll see additional Help menu items, one of which is 'Optimize database'. The extra Help menu items are generally intended for use when the user is being guided by Evernote support people, but are not generally needed. I may have optimized my database once, years ago; can't say that I've needed it since.

So now you know.

Share this post


Link to post
21 hours ago, jefito said:

And Evernote already does, but as a hidden (but not secret) support option, so I guess they count as 'intelligent', whatever that was meant to imply.

Anyways, Ctrl+click on the Help menu item, and you'll see additional Help menu items, one of which is 'Optimize database'. The extra Help menu items are generally intended for use when the user is being guided by Evernote support people, but are not generally needed. I may have optimized my database once, years ago; can't say that I've needed it since.

So now you know.

Tried this function  numberous times but never experienced any benefit. Seems to rebuild the entire database but that was not what I meant.

Never mind, not your fault. Same word (optimise), different meaning.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...