Forum Discussion
QuickBaseCoachD
Qrew Captain
Re:
I am just nervous as I continue to add more relationships to this note table (because I want to ultimately add a note on anything) all of these relationships are going to be very ineffective from a database speed side.
Quick Base works pretty fast when dealing with the typical number of records which humans can enter, so if you had 100,000 notes that's really not a problem for Quick Base. And as for the relationships, well Quick Base is lazy so it does not do more work than it needs to when you click. so you can have all sorts of crazy relationships and Quick Base does not get slowed down unless its needs to travel those relationships to render he record or reports on the screen.
So design the app how you need it to work for the benefits of the users.
This is not a million record issue where Performance is the Key design issue. You need the functionality you need.
I am just nervous as I continue to add more relationships to this note table (because I want to ultimately add a note on anything) all of these relationships are going to be very ineffective from a database speed side.
Quick Base works pretty fast when dealing with the typical number of records which humans can enter, so if you had 100,000 notes that's really not a problem for Quick Base. And as for the relationships, well Quick Base is lazy so it does not do more work than it needs to when you click. so you can have all sorts of crazy relationships and Quick Base does not get slowed down unless its needs to travel those relationships to render he record or reports on the screen.
So design the app how you need it to work for the benefits of the users.
This is not a million record issue where Performance is the Key design issue. You need the functionality you need.
JayWhite
5 years agoQrew Trainee
Okay, thanks! So is my logic appropriate? One master table of notes and relations to each table that I want a user to be able to add a "note" to? The only thing that is a struggle on that is I see on the forms it creates a "subtable" and they have to open the notes. I was more or less hoping to be able to create an experience where the user can read them inline. Much like the way we are communicating on this forum. I can types notes directly, save them, and users read them and see who posted them and when.