Page 1 of 1

attachments

Posted: Fri Jun 04, 2021 2:40 pm
by Bill
I occasionally add attachments (usually images and PDFs of articles [not full books]) to my notes, and even though we have discussed this here in the past, I am still not clear about how much bulk I am adding to a notebook when I do that. If a notebook contains an substantial number of attachments, is there any danger it will become too large? How much will it increase the notebook's size? Will search and other activities begin to slow down at a certain point?

Re: attachments

Posted: Sat Jun 05, 2021 8:45 am
by CintaNotes Developer
Hi Bill,
Attachments are compressed by CN and stored in a separate table in the SQLite database. Data is stored separately from attachment names, this means that when you search, the attachment data is not touched at all. So search speed shouldn't be affected too much. However, when the database becomes very large (more than 1GB), it may lead to slowdown due to the sheer time it is necessary to find and load the needed database page.

If most of your attachments are large (100MB+) and poorly compressable (video/media, archives, compressed pdf), it is better to put them into a separate folder and insert links to them into CN notes.

Re: attachments

Posted: Sat Jun 05, 2021 4:42 pm
by Bill
Thanks, Alex. I believe that all of my attachments would be well under 100 Mb. I will do some further experiments, and if the results seem to be of potential interest to others, I will report back here later.

Re: attachments

Posted: Mon Jun 07, 2021 3:17 am
by CintaNotes Developer
Ok, no problem at all. Will appreciate you reporting your results!