Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

how to improve connection resilience when loading large amount of records via json list?

Answered
Jeff Morsch asked on May 4, 2020

We currently load data from SQL into a list<dynamic> and json it and feed that to the FlexMonster Pivot Table via ajax
This works great onsite and from places with very solid internet.
But when an end user has poor internet that initial jsonresult download (which can be up to 100mb) often gets a ERR_CONNECTION_CLOSED, and the process never finishes.
is there a better way to handle this, or a way to implement a “resume” or “reconnect” when the connection is lost or closed?
Thanks
Technologies:
C#
MVC
SQL Server
 

4 answers

Public
Vera Didenko Flexmonster May 6, 2020

Hello, Jeff,
 
Thank you for reaching out to us. 
 
Our team kindly recommends trying the recently released Flexmonster Data Server, which is a new tool for connecting to databases.
It allows handling large data sets from different data sources, including Microsoft SQL Server database.
Using the Flexmonster Data Server could also provide a more stable connection.
 
We would like to provide some additional details on the way the data is loaded to the component when using the Data Server and why it is recommended to use it for large data sets.
 
The main advantage of such an approach is the fact that only the required for the current display part of the data set is loaded instead of loading the whole data set before it is displayed on the grid.
 
For more information about the Flexmonster Data Server and its usage please see the following guides:
1. Introduction to the Flexmonster Data Server
2. Installation guide
3. Connecting to the SQL Server database with the Flexmonster Data Server.
 
Please let us know if this would work for you.
Looking forward to your response.
 
Kind regards,
Vera

Public
Vera Didenko Flexmonster May 28, 2020

Hello, Jeff,
 
How are you?
 
We are checking in to ask whether you’ve found our previous response about using the Flexmonster Data Server helpful. Do you think the described approach would be suitable in your situation?
 
Please let us know what you think.
Looking forward to your response.
 
Kind regards,
Vera

Public
Jeff Morsch May 28, 2020

Hi,  
We have investigated the data server, but unfortunately it will not work for our application currently. 
We are using parameters in our queries for hundreds of reports.  We cannot cache the entire database.  Plus users can define new data queries dynamically in the application, which I’m not sure how we’d accomplish with the data server.
We are looking at some potential uses of the data server, however, and may make use of it in a different area of our web application.

Public
Vera Didenko Flexmonster May 28, 2020

Hello, Jeff,
 
Thank you for your reply.
 
In case a more custom approach is needed, we highly recommend implementing the custom data source API, which is a protocol developed by our team that the Flexmonster Data Server is built on.
The custom data source API greatly improves the performance and provides full control over how the data is processed. With this approach, it is possible to implement your own server-side connector to the data source of your choice and feed the data into Flexmonster already in the aggregated form.
For more information about how this can be done, please see the following guides: 
1) How to implement your own implementation of the Custom Data Source API approach: https://www.flexmonster.com/doc/implement-custom-data-source-api/
2) A sample implementation of the Custom Data Source API approach with Node.js: https://www.flexmonster.com/doc/pivot-table-with-node-js-server/
3) A sample implementation of the Custom Data Source API approach with .Net Core: https://www.flexmonster.com/doc/pivot-table-with-dot-net-core-server/
 
As for applying the Flexmonster Data Server in a different area of your web application, if questions arise along the way, feel free to reach out.
 
Please let us know if this would work for you.
Looking forward to your response.
 
Kind regards, 
Vera

Please login or Register to Submit Answer