How far did you push UR?

[cnewtonne]

Just thought of this as I was reorg'ing one of my UR dbs. How far did you push UR in terms of db size, count of tree items, and probably nesting levels. Of course, over how many years ...

Just attach a copy of file / properties box.

Here's mine ...

First one contains 5 years worth of technical procedures.
Second has 10 years of research.

[cnewtonne]

Here the the images.

[cnewtonne]

Here's thed 2nd one

[lascasas]

I'll play. My main file, since 2008. If a project gets really big, I use a separate file.

[ashwken]

From the main reason I settled upon UR...

[cnewtonne]

lascasas / ashwken,
I see that both have keywords set to a high value. If you noticed, mine is 0 and 1. I believe this is caused by the fact that I enabled enhanced full text search (EFTS). You know, all new db's are now created with this feature enabled by default.

I tell you, enabling this feature takes UR to a new level in terms of search performance.

Converting my existing 120mb db took less than 20 minutes. I recommend that you backup your largest db and convert it and check for yourself.


Thank you.

[dasymington]

Here's mine. This is the only UR file I use.

[lascasas]

I use enhanced full-text search and agree it's great. But I also use my own keywords to classify some things, and therefore I'm looking forward to the enhancements mentioned on the roadmap.

[cnewtonne]

dasymington ...
Why is your db this big?
- what type of content do you have in it?
- How many years?
- How's UR performance with such big db?

[dasymington]

cnewtonne, I use it for everything: work and personal stuff. It's got projects, correspondence, documents, any emails I want to keep. I do keep Word, Excel, etc documents as files on my hard drive but they're also imported and indexed in UR. It's got stuff going back to 1989.

Performance is fine; full text searches are almost instant.

[kinook]

My main URD file (used for notes, web research, RoboForm logins, documents, tasks, contacts, reminders, reference info, network/software inventory, etc.), in use since mid-2004 (before first public release of UR).

[kinook]

Other DB is an archive of all Kinook email messages and documents.

[Jon Polish]

This is my main file. Several years ago I was griping about performance issues. Kinook has improved the program's responsiveness in almost all areas, and I find it pleasurable to use.

The earliest entry I have dates to early 2006. This marks the beginning of my transition away from other PIMs.

Jon

[armsys]

How do you archive the large size attachments such as photos to emails? Do you store emails and attachments in UR?

[c&b]

Hm, if I ever was in doubt whether UR could handle large amounts of data, I'm not in doubt anymore :-)

[Semanticum]

My db properties here. I have been using UR for five years now and in the meantime I have one database only where I add all my daily business stuff. I am importing files (xls, doc, ppt, txt, pdf) without indexing them to not bloat the db. Instant search works fine and the size of the db doesn't matter anymore.

Dominik

[J-Mac]

Here's mine. I have been using this DB since June 2008 when I first purchased URp.

Thanks!

Jim

[cnewtonne]

Here one I created by importing technical documentation for major software platform.

[Metta]

This thread is amazing!

From the feedback everyone has shared is it safe to assume UR has an unlimited capacity?!?

Or, are there any performance issues I need to be aware of (in working with a larger database) other than the ones mentioned here: http://www.kinook.com/Forum/showthread.php?t=3627&highlight=database+size (http://www.kinook.com/Forum/showthread.php?t=3627&highlight=database+sizehttp://)

With appreciation and interest,
Metta

[cnewtonne]

Was bored for few hours this morning. I thought, let me push UR some more :) Not only, UR took all this data, it performed just fine. No noticeable degradation whatsoever.
Notice how efficient UR was in terms of memory: < 55MB.

Measuring performance: Times for
1) Opening UR DB: < 2 secs
2) Switching across info items: < 1 secs
3) Info items content scroll: Smooth. No slowdown
4) Search: single keywords: < 2 secs
5) Search: Phrases: < 2 secs
6) Closing UR DB: < 2 secs

I did this exercise to see how much data UR can handle in comparison to other tools I have been using lately. For example, About 2 years ago, I migrated my GTD database to Obsidian because I wanted to make it available on my iOS device. When the total size of the Obsidian vault hit near 2.5g after iCloud finished syncing it, Obsidian was no longer able to open the vault on iOS. It is been three days now and it is still stuck trying to open it.

Modern PKM's and note apps that use web technologies do provide great benefits in terms of portability and features. But, nothing comes close to native apps that are developed from the grounds up like UR. The fact that I have been able to use the same URD file for the past > 15 yrs is just amazing to say the least.

I'm back to using UR for my GTD (my entire life organized) and accessing it via a remote desktop app on my iOS.

One added benefit is that I have all my data on a home PC. No more using 'third parties' that take 'your privacy seriously' until they don't. Let alone possibility of cloud storage breaches what have been and continue to be a prime target for internet pirates.

[Jon Polish]

Although my main database is just a sizable fraction of your example, I completely agree with your observations.

Jon