QUICK BASE APP

A few of my tips (but I am curious to hear from the community):

One of the biggest things are queries. Avoid formula queries in large data sets, and definitely do not put formula queries on table reports, or as filters for reports. Be careful with formula queries in general.

The other thing that comes to mind is general search queries. For example, if you have a search widget on your home page, and it is searching 'every field', and there are 500 fields and 200k records, that will certainly degrade performance. In the field properties, you have the option to not have that field included in a search. Turn that off in all places possible. Utilize reports with minimal fields for queries in large tables.

Utilize relationships as often as makes sense, this is really the power of QB.

If you have many apps, if you are able to keep some separate from others (if you have many divisions in your business, or something that makes sense), do so. This will avoid them sharing resources. This is only applicable for those with large Apps, large companies, and many users. Thus, no cross app relationships, cross app report links, etc. 

Those are my first few, what do others think?

------------------------------
Mike Tamoush
------------------------------