Hi I have a dashboard which has a lot of companies (35k) to user level info and because of it the perfomace is really slow. we are using that internally and client side as well.
on the client side we wanted to a user list in such a way that each company have their own view. for which we used innerjoin . because of this will the performance will be better as the company filter is user at the data extract level once?
Also, When I record the performance the bulding of the dashboard taking 15 secs max and min 7 secs this is not causing a good user experience. Any tips would be really useful now
thanks,
madhu
Hi Mavis,
Yes, I am going to use inner join at the extraction. so that the user will see only their view. will that increase the performance?
