When I make a query from a datatype in which there is a field with a lot of information (loaded multi-item list) but using privacy rules I do not display this field, will the query still hinder the response times when reading on the server side?
It is clear to me that the data does not reach the client side.
Many regards, Alon
I believe you are doing a “Do a Search for”, in which case, the data type you are searching will retrieve all columns regardless of whether you display them or not.
So the answer to your question is YES the query will hinder the response time when reading on the server side.
Privacy rules will affect both the query and the return data. A query with constraints for fields hidden by privacy rules will always return a negative. Data returned will only consist of field values not hidden by privacy rules.
Bubble generally has very fast querying in place. It’s even encouraged in the manual to put more constraints in your search. It’s the return data (large data returned) that can choke the speed of a workflow.
So don’t worry about the speed of the query. Just be more precise with your search constraints and avoid advanced filtering :filtered if speed is a concern.
Thanks for the reply! This well known. The issue is with privacy rules. I “Do a search for” that does not return some fields which store a lot of data because of privacy rules. So no traffic is invlovled.
But is there any slowdown because of the mere volume of data that is stored with the datatype eventhough I do not download it because of privacy rules?
Thank!
But still, the fact that datatype (record in the DB) stores some huge fields filled with data, although not retrieved because of privacy rules, will it impact performance?
I believe yes !
From my experience and posts by others with even larger databases, there is no noticeable speed impact (if any) in regards to the actual search itself as long as the proper constraints are in place.
It’s the return that has a performance impact.
