Notion Google Calendar Sync ➡ bit.ly/3ZOQz9A 📝 Get Notion: bit.ly/3RCpbsZ 📚 My Notion Course: skl.sh/3W476DR ⚙️ My Notion Templates: www.riseproductive.com/notion-templates
I am a retired programmer. As datasets get big, there has always been database and interface tweaks to filter, sort, and limit. Content management systems for the masses will never be able to keep up. No-Code can only go so far...
I'm a software engineer. It's a relational database and you're pulling from 100 different sources to other tables that who knows what additional complexity. There is a thing called Big O notion. Your space complexity is off the charts. This isn't really a notion or database issue, but an issue of creating complex databases with no concern for optimization. Even if you created your own databases you would run into the same issue, or run out of money on cloud fee's. Notion is just calculating the complexity before running the query and dumping before executing. They are unaware people would need to think about optimizing the data.
At some point you'll always over do it and maximise the capability of any databases app unless it's fit for overloading but they aren't anywhere near as public or as cheap as Notion.
Yeah - this is the type of thing that caused me to start out really liking Notion, and then just being disappointed and annoyed by it. I started building and putting together a productivity system and organization method that works with my mind... however, as I started thinking in terms of "good database design" (used to do some DBA work many years ago) - Notion just started falling short. Sure, it's capable of implemeting some complexity, but eventually, there is a reason that both RDBMS systems as well as data warehoueses exist - scalability in their respective functions. The features/tools you use in those types of systems to solve performance and scalability problems - Notion just doesn't have them. Maybe when it comes to app design, instead of "fully coded" or "no-code", we need to think of it as a sliding scale. As your app or use-case gets more complex, the likelihood that you'll have to do some coding will increase. For instance, maybe in your case, you would eventually need to design a legit relational database in a proper RDBMS - but you could still have some no-code front end on top of it.
They built this for god knows who. I have similar problems with 150 records. I don’t know which company would be happy with Notion databases at this performance rate.
If I'm over 50 ppl, I'd look elsewhere and not get sucked into the mktg and hype. I'd be interested to hear what ppl ACTUALLY think at the notion day in SF
As a solo user for 4ish yrs now, my DBs are "huge". Editing my weekly and monthly review pages that have a lot of filtered and toggled content in them makes me want to repeatedly punch the screen. Imagining this for a small group of over 25 ppl, let alone 500, would possibly make a manager pull the plug. The platform doesn't need email. Doesn't need more cute fluffy stuff. It needs to run quick like obsidian, anytype, etc. Their dev team seems to be working in an echo chamber. I'd be surprised if they listened to advanced users. (A lot of those ppl moved to obsidian, logseq, coda, etc a while ago) Remember this. Notion's biggest pro: It's open-world. It's biggest con: It's open-world. The more and more and more you put into it, the heavier it gets. There are no "You may want to stop at 5000 blocks" kinds of bumper guards so over time those properties, formulas, synced blocks, graphics, huge DBs, templates, etc weigh it down
Weird Question. Have you thought about using Jira for this? It can handle millions of records with thousands of properties. It also has lots if integrations and automation possibilities.
Notion Google Calendar Sync ➡ bit.ly/3ZOQz9A
📝 Get Notion: bit.ly/3RCpbsZ
📚 My Notion Course: skl.sh/3W476DR
⚙️ My Notion Templates: www.riseproductive.com/notion-templates
I am a retired programmer. As datasets get big, there has always been database and interface tweaks to filter, sort, and limit. Content management systems for the masses will never be able to keep up. No-Code can only go so far...
I'm a software engineer. It's a relational database and you're pulling from 100 different sources to other tables that who knows what additional complexity. There is a thing called Big O notion. Your space complexity is off the charts. This isn't really a notion or database issue, but an issue of creating complex databases with no concern for optimization. Even if you created your own databases you would run into the same issue, or run out of money on cloud fee's.
Notion is just calculating the complexity before running the query and dumping before executing. They are unaware people would need to think about optimizing the data.
I've worked in the past week since making this video on optimizing my space to remove some of the rollups.
At some point you'll always over do it and maximise the capability of any databases app unless it's fit for overloading but they aren't anywhere near as public or as cheap as Notion.
Consider Obsidian :) properties and links paired with database functions work super well. And you own your own files. Obsidian is super fast too.
Yeah - this is the type of thing that caused me to start out really liking Notion, and then just being disappointed and annoyed by it. I started building and putting together a productivity system and organization method that works with my mind... however, as I started thinking in terms of "good database design" (used to do some DBA work many years ago) - Notion just started falling short.
Sure, it's capable of implemeting some complexity, but eventually, there is a reason that both RDBMS systems as well as data warehoueses exist - scalability in their respective functions. The features/tools you use in those types of systems to solve performance and scalability problems - Notion just doesn't have them.
Maybe when it comes to app design, instead of "fully coded" or "no-code", we need to think of it as a sliding scale. As your app or use-case gets more complex, the likelihood that you'll have to do some coding will increase. For instance, maybe in your case, you would eventually need to design a legit relational database in a proper RDBMS - but you could still have some no-code front end on top of it.
yeaaaaaah exactly
They built this for god knows who. I have similar problems with 150 records. I don’t know which company would be happy with Notion databases at this performance rate.
If I'm over 50 ppl, I'd look elsewhere and not get sucked into the mktg and hype. I'd be interested to hear what ppl ACTUALLY think at the notion day in SF
As a solo user for 4ish yrs now, my DBs are "huge". Editing my weekly and monthly review pages that have a lot of filtered and toggled content in them makes me want to repeatedly punch the screen. Imagining this for a small group of over 25 ppl, let alone 500, would possibly make a manager pull the plug.
The platform doesn't need email. Doesn't need more cute fluffy stuff. It needs to run quick like obsidian, anytype, etc. Their dev team seems to be working in an echo chamber. I'd be surprised if they listened to advanced users. (A lot of those ppl moved to obsidian, logseq, coda, etc a while ago)
Remember this. Notion's biggest pro: It's open-world. It's biggest con: It's open-world. The more and more and more you put into it, the heavier it gets. There are no "You may want to stop at 5000 blocks" kinds of bumper guards so over time those properties, formulas, synced blocks, graphics, huge DBs, templates, etc weigh it down
exaaaaactly
You going to have a similar issue in Google sheet if you try to build something really complex
Notion has a huge issue on mobile. Whenever I'm trying to edit page on mobile my text starts disappearing and moving here and there
I don't even bother opening the app
Try Coda.
I really need a native Call Webhook in notion!!
Weird Question.
Have you thought about using Jira for this?
It can handle millions of records with thousands of properties.
It also has lots if integrations and automation possibilities.
nope
You should definitely look into it. The UX might take some getting used to but the functionality is there
Thanks ! Very insightful
Greetings from Poland:)
Mobile app is a nope
Demetri - you need to work on your self-confidence brother 😂 Good work
I need to work on my humility
@@DemetriPanici And THAT is the first step, my brother.