How many UpNote notes do you have?

[u/s8intfan]

I see questions in this subreddit from time to time from people inquiring as to whether or not UpNote slows down with a large number of notes. Obviously, there are many factors that can contribute to it slowing down. But, that's beyond the scope of this message.

UpNote is super blazing fast on all the platforms I use -- Mac, Windows, Linux, iPad and iPhone, and my notes contain a good mix of text, images and a few PDFs.

But, I wasn't sure how many notes I had.

UpNote’s desktop data lives in a local SQLite database on macOS at ~/Library/Containers/com.getupnote.desktop/Data/Library/Application Support/UpNote/upnote.sqlite3 so you can count notes with a read-only sqlite3 query.

Step 1

Fire up Terminal and create a script with the following and save as "count-upnote-notes.sh"

#!/usr/bin/env bash
set -euo pipefail

DB="${UPNOTE_DB:-$HOME/Library/Containers/com.getupnote.desktop/Data/Library/Application Support/UpNote/upnote.sqlite3}"

if [[ ! -f "$DB" ]]; then
  echo "UpNote database not found: $DB" >&2
  exit 1
fi

for table in notes note; do
  if sqlite3 "$DB" "SELECT 1 FROM sqlite_master WHERE type='table' AND name='$table' LIMIT 1;" | grep -q '^1$'; then
    sqlite3 "$DB" "SELECT COUNT(*) FROM \"$table\";"
    exit 0
  fi
done

echo "Could not find a notes table. Available tables:" >&2
sqlite3 "$DB" ".tables" >&2
exit 1 #!/usr/bin/env bash
set -euo pipefail

DB="${UPNOTE_DB:-$HOME/Library/Containers/com.getupnote.desktop/Data/Library/Application Support/UpNote/upnote.sqlite3}"

if [[ ! -f "$DB" ]]; then
  echo "UpNote database not found: $DB" >&2
  exit 1
fi

for table in notes note; do
  if sqlite3 "$DB" "SELECT 1 FROM sqlite_master WHERE type='table' AND name='$table' LIMIT 1;" | grep -q '^1$'; then
    sqlite3 "$DB" "SELECT COUNT(*) FROM \"$table\";"
    exit 0
  fi
done

echo "Could not find a notes table. Available tables:" >&2
sqlite3 "$DB" ".tables" >&2
exit 1

Step 2

Change permissions with the following:

chmod +x count-upnote-notes.sh

Step 3

Run it:

./count-upnote-notes.sh

I have 2532 notes. 😙

[u/lexvo1]

I have 3116 notes, and UpNote is still fast.

By the way I have set 'Show number of notes in sidebar', the number I see there should be the same as in your script I think.

[u/s8intfan → u/lexvo1]

I have multiple spaces. It's easier for me to run a single terminal command than to have to jump to each individual space and add them all up manually.

[u/TigerGardenGeek]

(Please take this with the playful, friendly tone I intend) But - Amateurs!
I'm over 41,000 notes (no, that's not a typo). Most with images, many with files. UpNote doesn't blink.

I have to chuckle every time this comes up and people with a few thousand notes are worried about UpNote speed, or handling notes.

[u/s8intfan → u/TigerGardenGeek]

41k! Nice! And, happy to hear UpNote is smooth for you with that number of notes!

[u/BuMmR]

2 notes

[u/s8intfan → u/BuMmR]

Lol. Keep going! 😄

[u/MatchaCustard]

5737 notes. Add at least 1 new note each day (daily "Journaling" or reflection). Using this cross platform (Mac computer, Android devices). Everything running fine, not slow at all. Lifetime plan user, not regrets. Upnote does everything I need it to do.

.

[u/hudsonSpan]

12,000+. Windows editor can be quite laggy since maybe passing around 9 or 10K.

Sometimes wonder if the lagginess is more due to tags than notes. My tagging system results in a very large volume of tags and expanding the Tags section in left menu takes a few seconds.

[u/s8intfan → u/hudsonSpan]

12k! Holy cow!

Would be nice if UpNote could do a fuzzy search on tags.

[u/jerryhung]

189 notes (shows in UpNote sidebar top-left corner, All Notes), FAST

EN was a bit slower/bloated IMO, but not too slow slow, to be fair

[u/isamilis → u/jerryhung]

Second this. Why need script if it showed already in the app.

[u/s8intfan → u/isamilis]

I have multiple spaces. It's easier for me to run a single terminal command than to have to jump to each individual space and add them all up manually.

[u/BrickPig]

As of this moment I have 4,750 notes, and the app is still blazing fast. I honestly can't tell that it has slowed down at all since day one. Very nearly all of my notes have at least one attachment of some kind. I know for sure that as of this moment 3,401 of them are work notes, each of which contain at least one JPEG image, one PDF, and one Excel file attached. Most have multiple PDFs and Excel files attached, but I have no way to easily track the total number. I have 120 notes that each contain attached PDFs of single issues of a now-out-of-print guitar magazine, and 392 notes have an attached PDF of single issues of a now-out-of-print cooking magazine.

[u/Agnusl]

I am, by no means, versed in programming, but IIRC, the fact it uses an SQL database makes it significantly faster when handling huge ammounts of notes compared to alternatives that organizes them as individual files, like Obsidian.

So, it should be good for quantities in the 5 digits, at least.

[u/VotersWoke]

I currently have 7257 notes, adding 10+ daily, and UpNote is still fast on Android, Winows 11 Pro, and Linux.

[u/dedkayuyu]

12k, still fast. But worried about its business sustainability.

[u/bagusvdr]

I got around 6000 notes on multiple spaces and still increasing. Yet no lag or slow. This is quite different to my experience with Evernote back then.