Property Optimisation - Difference between "Optimise for reporting" and via PRPCServiceUtils
Hi Team,
If we are trying to optimise some properties in a class with lot many instances. Which approach is ideal out of the two ? (without running into issues like util node going down)
I have the following questions :
Are we directly hitting the database through PRRestService ?
Is there a timeout incase the number of instances are huge ?
And is there a way to selectively populate the columns ?
Will this get recorded in the audit ?
@AkhilGangadharan
I could be wrong but here is my understanding of different expose property options -
Solution 2.1 can be executed either in sync or async mode. requestTimeOut param most likely relevant to sync mode (making an guess here as nothing clearly specified on article).
Solution 2.2 directly submit data copy query to your DB. If your DB has any limit on runtime of a query, that will be in force.
Hope it helps.