Is it possible to call custom APIs in parallel during creating pivot table?

Hello,

Thank you for contacting us.

Please find our answers below:

1. I think each piece of data could be retrieved independently, so why are they being called serially?
   In the current architecture, Flexmonster processes responses sequentially. That is why each request is handled one after another.
2. Can these APIs (/members and /select) be modified to be called in parallel?
   The APIs (/members and /select) cannot be executed in parallel with the current design. The component is ready to accept only one response at a time. Supporting parallel calls would require a fundamental architectural change.
3. The first call to the /select API takes a very long time. Can this latency be improved?
   To better understand your use case, could you please check how much time this operation takes directly on your server (without Flexmonster)? Sometimes, it can be caused not only by the component but also by how fast the server responds.
4. After the first call to /select, can the remaining calls be called in parallel?
   Parallel processing is not possible in the current architecture.

We are aware of the current architecture limitations. However, it does not allow changing such aspects without a complete redesign. This is why we are working on the new Flexmonster 3.0 version, where we have already achieved significant performance improvements. Although the custom data source API will not be supported out of the box in the initial 3.0 release, we will include it in subsequent releases.

You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Hello,

Thank you for the response.

Yes, you are correct that, with the current architecture, the only way to improve the performance of a custom data source API is by optimizing the server-side logic and queries.

Please let us know if other questions arise.

Kind regards,
Nadia

Hello,

Thank you for the response.

For version 2.9, we release minor updates with fixes every two weeks. However, we don’t plan to rework the custom data source API architecture in 2.9.

Our team is currently focusing on Flexmonster 3.0, which will introduce the custom data source API in the new architecture. Please note that the custom data source API will not be available immediately with the first Flexmonster 3.0 release. It is planned for the upcoming releases. We regularly update our roadmap with upcoming features and improvements, including more accurate time estimates - check it out here: https://prerelease.flexmonster.com/roadmap.

Feel free to contact us if other questions arise.

Kind regards,
Nadia