This topic discusses the guidelines and limitations while handling bulk data on krewDashboard.
Following usage may have impact on performance. So, in order to optimize the performance, we recommend you to set the design while keeping these points in mind. Performance also depends on the PC specifications and network environment.
- When record count or field count in source data apps of each chart is huge
While krewDashboard doesn't impose a limit on the number of records, retrieving data through the kintone API could take longer if the data app contains a large number of records or fields. And, retrievng data through the kintone API becomes a bottleneck in terms of performance, especially when processing the entire krewDashboard contains a large number of records.
Furthermore, it should be noted that the kintone API can only retrieve a maximum of 500 records in one go. Consequently, the number of API requests will rise in proportion to the number of records.
Example) If 20 users open a data app dashboard containing 10,000 records 50 times a day : 10,000/500 x 50 = 1,000 request
- kintone has a limit of 10,000 API requests per day per app.( Refer to The number of API requests available per day）
When Record and Field Count is Large
When number of records and fields is large in a data app, you can improve the performance by using following method.
- Filter the retrieve records using Global Search
A method that can be considered by all users is the "Global Search". You can reduce the number of records to be retrieved by setting the filtering conditions for the referring app on the dashboard in advance.
- Use the Group By command of krewData to aggregate the large data and use already aggregated data as data app in krewDashboard
Aggregate the app records in advance with krewData and output them to another app. With krewDashboard, you can reduce the number of records retrieved by referring to the app after aggregation. Moreover, it diminishes the number of fields in the app, thereby decreasing the time needed to retrieve records.
- When number of fields is large in a data app, arrange a data app with reduced number of fields to improve the performance.