Forum Discussion
MichaelTamoush
Qrew Captain
Austin - when speaking about app size for sandbox, does that include file attachments? If so, I'm dead in the water because we track assets (equipment) and have roughly 20,000 assets, each with about 5 pictures.....or 85 gigs worth of attachments. Without attachments, my apps are tiny.
Blake - when you mention workflows, what exactly are you referring to? Automations etc?
Mark - thanks for the tips. My largest table only ha maybe 20,000 records. I can see some tables growing but it will be many years I imagine until I even reach 100k in one table.
I have a couple massive (I think? I have no frame of reference) tables of 500+ fields. So far so good, except my main table I ran out of Dynamic Form rules, so i will have to take some time to clean that up and rethink some of the fundamental design to alleviate that issue.
I like to keep my user roles small, also for ease of management, but still need 6-8 roles. Which multiplied over three apps already starts to wear on the management.
Sounds like this can really have a list of pro's and cons each way.
------------------------------
Mike Tamoush
------------------------------
Blake - when you mention workflows, what exactly are you referring to? Automations etc?
Mark - thanks for the tips. My largest table only ha maybe 20,000 records. I can see some tables growing but it will be many years I imagine until I even reach 100k in one table.
I have a couple massive (I think? I have no frame of reference) tables of 500+ fields. So far so good, except my main table I ran out of Dynamic Form rules, so i will have to take some time to clean that up and rethink some of the fundamental design to alleviate that issue.
I like to keep my user roles small, also for ease of management, but still need 6-8 roles. Which multiplied over three apps already starts to wear on the management.
Sounds like this can really have a list of pro's and cons each way.
------------------------------
Mike Tamoush
------------------------------
MichaelTamoush
4 years agoQrew Captain
Another question - I have one table that I have what seems to be an absurd number of report links (20ish). It's been a good way for my users to be able to view a lot of information in one place, but I suspect this is a bit tedious for QB? I've considered being very selective in which ones I actually display (which right now is all of them) versus just displaying a link. I suspect this helps the speed in which the record will load, but I am not sure.
Right now, the record can be cumbersome to open in edit mode. However, I wonder if this is a browser limitation as when opened on a mobile device it's quite quick.
Does anyone have any experience/tips/thoughts on report links?
------------------------------
Mike Tamoush
------------------------------
Right now, the record can be cumbersome to open in edit mode. However, I wonder if this is a browser limitation as when opened on a mobile device it's quite quick.
Does anyone have any experience/tips/thoughts on report links?
------------------------------
Mike Tamoush
------------------------------
- MarkShnier__You4 years agoQrew LegendBest practice 99% of the time is to set the form the way it defaults which is to have report links fields load the child tables separately and use Tabs for Desktop forms to allow Quick Base to present the form to the user with the minimum number of report link child tables populated. That takes a lot of load to say run 8 reports and maybe the user only cares about or two of those child tables at that moment. They would probably load fast in mobile because they only have to pull the data when you click to view the report.
If you can put embedded reports in Tabs, then the system will not try to pull the report(s) unless the user clicks the Tab.
Quick Base is single threaded for all basic operations, so if the form takes 3 seconds to populate then every other user is frozen until that form loads for those 3 seconds.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------