Hello,
I would like to clean up my searchable fields, assuming this will improve QBASE performance. Any suggestions on what field types definitely don't need to be searchable?
thx
------------------------------
BuildPro
------------------------------
Question
Clean up Searchable fields - best practices
+11
+17Hi BuildPro,
One field type that can be very intensive is Multi-line text blocks. If you have sections where users might be entering paragraphs of text removing them from search can help avoid situations where people look for text strings against big blocks of text if that is not your intention. The same is true for any formula or relationship fields you have in your app that someone wouldn't want to search against. For example if you are using formula fields in the background for calculations that wouldn't need to be searched on reports or if you are using fields to style text you usually don't want to include both fields in a search as that is duplicative.
------------------------------
Evan Martinez
------------------------------
One field type that can be very intensive is Multi-line text blocks. If you have sections where users might be entering paragraphs of text removing them from search can help avoid situations where people look for text strings against big blocks of text if that is not your intention. The same is true for any formula or relationship fields you have in your app that someone wouldn't want to search against. For example if you are using formula fields in the background for calculations that wouldn't need to be searched on reports or if you are using fields to style text you usually don't want to include both fields in a search as that is duplicative.
------------------------------
Evan Martinez
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.