Creating Notes Table for CRM and Contacts
Hello, thanks in advance for the help. I am creating a project management app complete with CRM. I want to create a Notes table so a user can save notes on any particular object to track progress. I w...
Forum Discussion
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.
Got it, that works. Yes in part that was the question. Plus just making sure that the relationships and number of records would not be an issue.