I currently need to cache about 3200 csv files of large data in the Flexmonster data server.
I have a question.
1. Flexmonster maximum number of files per server,
2. Maximum capacity per file,
3. What exactly DataRefreshTime does,
4. Whether you can run multiple servers (per port),
5. I wonder if the CacheSizeLimit option means the maximum number of files that are cached, and if so, what is the maximum value of the CacheSizeLimit option?
Hello,
Thank you for contacting us.
DataRefreshTime
property defines how often the data is reloaded from a file or a database. It means the data will be reloaded from all specified files every sixty minutes in case the value of the DataRefreshTime
property is set to 60.
CacheSizeLimit
defines the maximum number of cached server responses for every index. It means the server will store 10 recent responses in JSON format in case the value of the CacheSizeLimit
property is set to 10. It allows reducing the time needed to process the data - in case the response is cached, the data will be returned instantly.Finally, our team would like to draw your attention to the fact that the mentioned amount of files is unlikely to be handled by the majority of servers. Therefore, we suggest considering developing your own implementation of the custom data source API that would hit the corresponding CSV file every time the data needs to be displayed. It would significantly reduce the load on the server due to the fact that the whole processed file is not stored in your server's RAM.
Also, your own implementation of the custom data source API would allow composing dynamic queries, as discussed within your other forum thread.
We hope it helps.
Please contact us in case further questions arise.
Kind regards,
Illia