do excess columns slow down a database?
Options
![Mitch](https://us.v-cdn.net/6037124/user_avatars/2157194.jpg)
Mitch
Member ✭
I get that there's a point where records can do that, but is it the same for columns? Currently, my members database has about 40 columns. They're not all essential fields, and could be broken off into other databases, but for birds-eye views, I liked having it in one place... except if it can slow things down...
Also, how would we know when we're losing speed? I know that we can speed when debugging. But even so, I have no idea when "good" starts to become mediocre...
Thanks!
Also, how would we know when we're losing speed? I know that we can speed when debugging. But even so, I have no idea when "good" starts to become mediocre...
Thanks!
Comments
-
Hey Mitch this isn't a simple answer to a simple question. It really depends but in short, I think you are fine. But you bring a good point. You might consider breaking things up into related tables if it makes sense from an organizational standpoint and database management perspective
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback