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.
- 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.
- On the form where you have the report link field probably called [Notes] set the form property to display the notes directly on the form.
Was that your question - how to get those note records to immediately display on the form? - 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.
- Many of us can show you relationship diagrams that look like a plate of spaghetti. Way more complicated that what you have here.
Apps quite typically can have several dozens of tables and hundreds of relationships and perform quite nicely. The main issue to slow apps down is when there are high record counts and summary fields in heavy use on reports and forms combined with say 50+ say heavy concurrent users.
