"vlad" wrote:One thing I can tell for sure - we did our best to make secure, safe, and fast storage for your sensible data.

And you've certainly succeeded! I'm always amazed with how quickly AllMyNotes opens (from the task bar) and how quickly Global Search works, regardless of how large my DB gets.



Thank you for the very detailed explanation about how the DB's size is managed. Now I also understand why sometimes when I put something into AllMyNotes, the DB's size doesn't change by much.

Database size logic is pretty complex thing, in addition to actually stored data it also includes:

• 1. Internal data indexing tables needed for fast data access. For example to keep Global search fast even for very huge data volumes
  
  2. Sometimes database engine may simply pre-allocate some extra space to minimize data file fragmentation. There are two levels of data file fragmentation - fragmentation of .dbb file on HDD, and fragmentation of data records within .ddb. Both we’ve cared about. For example, you may notice that after deleting a Note .dbb file doesn't get's smaller, at least not immediately, we do have smart internal data defragmentation algorithm, and it can be either called manually (use File -> Properties -> Defragment), or on exiting from app (partial quick defragmentation).
  
  3. AllMyNotes stores duplicates of critical data areas to avoid data corruption (which may happen, for example, due to hardware failure) and provide better compatibility with older/newer app versions. Particularly, each note is stored in Rich Text, and in Unicode plain text formats, and if, from whatever reason, Rich Text or Unicode copy is be damaged, then another data copy can be used. It takes bit more disk space, but data has too high value and data safety is worth some extra disk space.

Therefore please do not wonder about .dbb size, it's related to data inside, but not linearly, there are many other factors that influencing on it, except described above. One thing I can tell for sure - we did our best to make secure, safe, and fast storage for your sensible data.

Vlad,

Today when I pasted a 90KB PDF file into AllMyNotes, the DB's file size increased by 1MB (approximately). I thought that maybe this was just a temporary allocation of extra space, so I exited from AllMyNotes and then reopened it, but the DB's size remained the same. I then 'cut' the file from AllMyNotes (and exited and reopened again), and then pasted the file back in. I checked the DB's size and I found that it had increased by the amount it should have, which was about 100KB. So somehow copying the file from AllMyNotes and then pasting it back in caused the correct amount of space to be allocated.



This is probably working as designed, but in case it's not I wanted you to let you know what I observed.