It implies using a direct JSON/CSV connection instead of the Data Server. Therefore, we suggest considering one of the following approaches. Updating the data every minute (the smallest possible value for refresh) also may not be an option since reloading takes a long time to complete. Flexmosnter Data Server does not fetch the latest data from the database every time a request is made (F5 in your case). This approach also exposes limitations on the updating process. However, after completion, this allows all the requests from the client to be performed fast. This is why the first launch of the Data Server or further reloads may take a long time to complete. It takes some time to fetch the data from the data source and process it, especially when operating with large datasets. The data will be reloaded according to the refresh time. If refresh time is 0 or undefined, the Data Server will not reload the data. Please note that Flexmonster Data Server fetches the data from your database and stores it in the RAM of its host. Is there a way no data server as DLL to do not try to run the big query to get the fields? Is there any configuration (both data server as service or DLL) that makes everything updated on browser refresh (F5)?.The filter was not used (the method "_apiService.GetFieldsAsync(request) " inside "public async Task PostFields(FieldsRequest request)" does not accept filter.Īfter an F5 is pressed, the response was fast and my data was outdated. ![]() I've tried to use the Data Server as a DLL as well, to use the Data Server filter, but the first time the user opens the pivot table, the query "select * from MY_VERY_BIG_TABLE" runs and takes REALLY long time to complete. Every time i did the F5 on the browser, the response from data server was fast and the data displayed was outdated. Using the Data Server as a service this was not possible, even when i configured the refresh time to 0. When my users are using the pivot table, the data needs to be updated as the user presses F5. When I save the index, Data Server fetches all records from my table to the memory (or whatever)! On the Query field i did the "select * from MY_VERY_BIG_TABLE". I did the tests with de Data Server (as a windows service): Please let us know if any additional questions arise. We suggest checking out our documentation dedicated to Connecting to a Microsoft SQL Server database using Flexmonster Data Server. Moreover, Flexmonster Data Server works with Microsoft SQL Server database out of the box and can fetch the data directly without the current C# tool mentioned in your question. This approach allows operating with up to ten times bigger data sets than direct JSON connection. It means Flexmonster does not need to wait for an entire data set and perform all the heavy calculations on the client side. It is also important to note that only the data that needs to be rendered on the grid is sent over the network. Next, the ready-to-show data is sent to the client and displayed instantly. It performs all the heavy operations (aggregating, filtering, sorting, etc.) on the server side. In its turn, Flexmonster Data Server serves as a middle layer between your data storage (Microsoft SQL Server) and client-side Flexmosnter component. We recommend directly connecting to JSON when the data set size is less than 100-150 MB. The mentioned data set size may turn out too big for an average client's machine. It means Flexmonster waits for all the data to be passed over the network, then it processes the data using the client's machine capabilities. ![]() In this case, all the data (1M records, 60 columns) are loaded to the client-side and processed at once. When the Data Server is not used, Flexmonster loads the exported JSON data directly from the server.
0 Comments
Leave a Reply. |