During peak business days our production instance is experiencing slow performance.
For example default views are timed out and does not load. This makes me think how data in view is loaded. For example there are lakhs of case records and the default view is active case , instead of my active case. Can this have an impact ? If at all the view is active cases , doesn't the view loads only maximum 250 records intially ? and there shouldnt be an impact based on laths or rows or few thousand rows right ?