Currenty, my database have lots of data with lots of columns to show commoditys prices for a client. Show them historic views about soy, coffee and others. But how this can be better optmized? I see lots of workloads being consumed just with a few testers, and I need to check hundreds of records in a datatype to generate graphs. I changed how many times a list is called, so I generate a repeating group that populate many graphs. Still many workloads are consumed. Is there any other way?
The first thing I do when optimizing my WU is to check the WU pie chart.
How does yours look like? I assume realtime data takes a huge chunk?
Hello. Yes, fetching data and Page loads are the major consumption in metrics view.