How Big Is Your Database?

Started by: Ken45140 on Nov 17, 2019 7:05 PM

vlad
Post #1 - Dec 1, 2019 1:13 PM
Re: How Big Is Your Database?
There is no limit on database size. And overall DB size has no effect on program startup performance :)



We can only recommend to keep individual notes in reasonable size. Let's say if a note is under 100Mb size it's pretty good. Larger then that may affect slowdown when opening these notes.



Major thing which eats disk space is big file attachments. Images are Ok, these are compressed (we using lossless PNG compression), but file attachment can be very big, therefore we recommend to create hyperlinks to files on a disks rather than inserting them in to the database.
Ken45140
Post #2 - Nov 17, 2019 7:05 PM
How Big Is Your Database?
I am curious. What are some of the largest databases in use for AMN users. The properties link on my total database says:

425 MB, 1239 Notes in 350 folders. I suspect I am among the smaller databases in use. I keep all of my data in one database rather than breaking the information up among several databases. From important file data (license plate, car registrations, credit card info, etc.) to medical records, medical research, company stock analysis and information, recipes and receipts ---- everything. Yet I am still on the way to making my record keeping even more complete.



I copy (using click.to) many articles (especially stock analysis and medical research) and images in the original articles come in fine and trouble free. In reviewing the copied article, I will delete some of the images that are not relevant, but will enlarge images (like a stock graph or table) by dragging the bounding corners of the image. I assume that an enlarged image still contains the same number of bytes and does not increase the size of the database, and in turn, deleting irrelevant images decreases the size of the resulting database. Is this true? (vlad??)



What size is your database?



Ken

Post Reply

📝 Anonymous posting: Your message will be reviewed by moderators before appearing publicly.
Please answer "NO" to have your message delivered!

🛡️ Vladonai Secure Community Platform [BETA]

Powered by Vladonai Minimalistic Forum Script | Designed for AllMyNotes Organizer Community

🔐 Login via Dashboard for full forum privileges

© 2025 Vladonai Software | AllMyNotes Organizer Community