Rollbase and charts: taking a long time (upwards of 5 minutes) for charts to populate with the data. Using the Hosted Rollbase Model
* Number of records returned: Looking at an indexed text field living in about 47k records
* Which engine are you using: Fusion Charts (Flash) or Google Charts (HTML): Both. Doesn't seem to matter much.
* Narrow down the data set to a smaller set of records: Tried on the Contacts object, about half the size of the Accounts Object and had the same results...took a long time.
Is anyone else experiencing this? Do you have any tips that you can share?
Thanks!
It sounds like you have some of the obvious questions out of the way:
- number of records
- Google Charts or Fusion
- indexing key fields
With 50K records you do get into concerns of the the efficiency of the query, and the time needed to transfer the data to the browser (and finally the complexity in the charting package of the rendering).
Are you trying to display all 50K records? If you change the chart to showing a Count of records , or a summary calculation on the data is there any difference in time? The fact that you don't see a difference between Fusion and Google charts leads me to think it is the query or the data transfer? You can check the data transfer with a TCP/IP monitor (there is one in Progress Developer Studio for OpenEdge, or use the Tools in Google Chrome).
The call to populate the chart can be seen in the Chorme Tools >> Network view. Look for a call of the form
Ajax?rnd=...&cmd=chartData&chartId=...
Check the timing (particularly Waiting) and the size of the response (how big is the section for data.addRows(...)
e.g. data.addRows([['1900', 2.0],
['1978', 1.0],
['1987', 1.0],
['2012', 1.0],
['2013', 4.0]]);