When using large data for Flexmonster,
what is the difference between connecting a DB using Flexmonster data server and sending a query to receive the data?
Thank you for your question.
The main difference between the mentioned approaches is the way the data is transferred to the client-side.
When the direct query is used in order to load the data to the component, the whole data set needs to be transferred over the network, parsed, aggregated, and filtered on the client-side. This means that the client machine’s RAM determines how much data can be loaded at once, and CPU capabilities affect how much time is spent on data processing. Large data sets are hard to load over the network and process using limited client’s browser’s capabilities.
In its turn, Flexmonster Data Server is a server-side tool, that relies on the computing power of the server. It fetches the data from the data source (for example, the database), processes it, and aggregates it directly on the server. Then, Flexmonster Pivot gets the required data in a ready-to-show format.
Moreover, only the data that needs to be currently displayed is loaded to the client-side. It means nothing but required parts of the data need to be transferred over the network and stored on the client’s machine. Such an approach significantly reduces the time needed to deliver the data to the final user and allows operate with much larger data sets.
We recommend referring to our blog post dedicated to the Data Server in order to get additional details about the tool.
We hope it helps.
You are welcome to contact us in case any additional questions appear.