Single Large Database vs Multiple Single Topic DBs

Started by: Ken45140 on Jul 16, 2019 11:44 AM

Ken45140
Post #1 - Jul 16, 2019 11:44 AM
Single Large Database vs Multiple Single Topic DBs

As I am in the process of maximum use of AMN (with conversion of many notes from OneNote and Evernote), I would like to have experienced perspective on the following organizational question:

What are the pros and cons of having one large DB (database) with many subjects as Tree items vs multiple smaller DBs restricted to their own topics?

Large DB might be

MyData

HEALTH TOPICS

FINANCIAL TOPICS

PROJECT TOPICS

vs

HEALTH DB

EXERCISE TOPICS

DIET TOPICS

DISEASE TOPICS

and

FINANCIAL TOPICS

BUDGETING TOPICS

INVESTING TOPICS

SAVINGS TOPICS

and ETC. Please tell me your experiences and opinions on this. I certainly will appreciate your advice.

Thanks,

Ken

Ken45140
Post #2 - Jul 24, 2019 1:13 PM
Re: Single Large Database vs Multiple Single Topic DBs

I sure wish I could see some replies to this question. It seems an important one, especially to those just starting out with AMN.

If you see this and have some insights, please reply.

Thanks much,

Ken

vlad
Post #3 - Jul 24, 2019 3:24 PM
Re: Single Large Database vs Multiple Single Topic DBs

Usually we recommend single storage file and multiple folders within it to categorize your data. This way you can have all your data searchable and available for browsing at all times. There is no performance issues - AllMyNotes keeps all data on a disk, it only loads currently edited note, so no need to worry about anything. No matter how your data file is, it start up instantly and uses minimum of RAM.

CraigL
Post #4 - Jun 7, 2022 12:21 AM
Re: Single Large Database vs Multiple Single Topic DBs

I'm a writer, with various projects going on at the same time (e.g., technical writing project, fiction story, someone's blog articles, etc.)

What I've found most practical is to have 1 "Personal" AMN database, and numerous dedicated separate files for each main project.

A "project" can be, say, a client or it can be a particular group of articles.

For example:

"My Diary" handles to-do lists, dates, reminders, quick ideas, and whatever goofy stuff I want to remember while I'm on the computer.

"ABC Corporation" is a client who hires me to write an instruction manual for an in-house software application.

"Great Novel" is a book I'm hoping to publish someday. It can have rough ideas for things, or written drafts. I can have a folder for "Characters," and do the character development. I can have another folder (in the same file) for "Chapter Outline," with summaries of each chapter to come. And so forth. I generally write the actual chapter in something like MS Word, because it has to be submitted to copy-editors and publishers, who may not have AMN.

Another dedicated file might be, "American Blog," where I do the same as with the novel, only ideas for articles to post as a guest author. "Clients" might be a Folder in my "Diary" database, with separate sub-folders for each blog site (if I have multiple different blogs at a time) or client.

I can link to "file" from within my own Diary, and open that particular database easily.

Each database can easily insert links to either somewhere in one file, or to another file entirely. The "global search" feature helps me to find out whether Johnny Badguy is a smoker or non-smoker.

I've used various outliners and information managers, but have always missed InfoSelect. Now, with the modern AllMyNotes, I get the best of all worlds. So my recommendation has to do with how your mind processes information.

1. Determine major categories of entire bodies of information (like the clients, projects, books, diary, etc)

2. Choose the same folder on your computer to store all the AMN databases. Makes it easier to backup everything to a stick drive.

3. Name each database file with a recognizable filename so you can find it easily in generic file explorers.

4. Divide each database in its own Tree structure, with "large" but not global categories.

So a book might have a Folder for all Chapters, but another folder for each article, character, or whatever.

This makes it easy for multiple submitted articles to the same place. For example, if I have an individual file for "Blog Writing," I can have separate Folders for "Blog 1," Blog 2, and Blog 3. Under "Blog 1," I can have sub-folders for "Article A," Article B, Article C.

Then I can have a sub-folder for "Payments." So

File: Blog Writing.

Folder: American Industry

Note: January article

Note: February article

Folder: Political Ninja

Note: November elections

Folder: Payments

Note (or sub-folder): American Industry - article title, submitted date, invoice amount, expected payment receipt. What's nice is these can each have "checkbox" events to keep track.

Organize your mind, and the computer will follow along. :-)

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

© 2026 Vladonai Software | AllMyNotes Organizer Community