How to ensure that System Performance is not impacted by database query run in the back ground

[Ankita Gupte]

How to ensure that System Performance is not impacted by database query run in the back ground. We have one field to segregate between two companies A & B such that A company cannot view B company tickets and vice versa. So every development we do for company A we have to ensure to apply query that company is not B in catalog item variables, Table fields etc. So everytime this query will run in backend checking millions of data. In this case how we ensure that system performance is not impacted.

[Mark Manders]

Why not apply read acl's so you don't need to run this as DB query? With the 'deny-unless' ACL's introduced in Xanadu, this should be easy.

Let's say the segregation on incidents is on 'company' field:

table = incident

applies to = company is A

deny unless = current_user.company = A

and vice versa for company B

[Ankita Gupte]

Hi Mark,

Thank you for update, will definitely check on the recommended way of configuration but we have already configured based on company field. So now with existing configuration how do we ensure that system performance is not being impacted.

[Mark Manders]

To move away from querying millions of records in the backend. Your solution will impact the system performance. A solution once thought up may very well no longer be the best solution (in fact: the solution impacts performance, so by definition isn't the best). Keeping it because it's already there, will also keep the issues you have with it.