How Big Is Your Database?

Tips, tricks and how-to discussions

How Big Is Your Database?

Postposted Ken45140 » November 17th, 2019, 5:05 pm

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
Ken45140
 
Messages: 22
Member since:: July 2nd, 2019, 7:12 pm
City/Country: Loveland Ohio USA

Re: How Big Is Your Database?

Postposted vlad » December 1st, 2019, 11:13 am

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.
AllMyNotes Organizer usage example: a genealogy tree organizer, and, BTW, use alarms to remember about anniversaries and birthdays
vlad
Site Admin
 
Messages: 1017
Member since:: January 6th, 2011, 2:58 pm
City/Country: Earth -> Europe


Return to How Do I...

cron