Hello,
I want to export huge data like >10lakh rows (>1crore values). I am not able to fetch this type of data through any API as there are memory constraints for any backend language that is around (10lakh values). How can I download excel values directly from a SP through database directly. If you have any other alternative solution to this we are open to use them as well. Thanks for your help in advance.
Hi Ekshu,
Thank you for posting to Infragistics Community!
I have been looking into your question and in order to be able to assist you, I would like to ask you to please, clarify your requirement a bit more. I understand that your question is about loading a huge number of records, however, I am afraid I am not certain what is meant under “download excel values directly from a SP through database directly”. Could you please clarify what “SP” means?
Additionally, could you specify which Ignite UI for Angular component you are using? Are you trying to bind data to it, for example if it is the IgxGrid, or is it something else?
This information will be highly appreciated, so we can continute assisting you. Thank you for your cooperation.
Best regards, Bozhidara Pachilova Associate Software Developer
I am using IgxGrid only. I want the grid to fetch the data directly from Mysql database SP(stored Procedure) as there are memory restrictions in any language due to which we are not able to pass 1 crore values through API's. If you have any alternate solution to this that how can we fetch more values in our springboot project then also we are open to look up to that solution. Or if there is any way we can bind data from Mysql database SP(Stored Procedure) with IgxGrid then also please tell us.
Hello Ekshu,
I understand what you mean, although, I am afraid such question would be out of the scope of Infragistics components, since it concerns matters not related to our components, such as data implementation, storage and backend API.
Apart from the most basic approach for data binding, that is setting the data property of the igx-grid with an already fetched data collection in its entirety, the grid exposes API for remote data operations.
Please, check out the Remote Data Operations topic in our documentation, where features such as Remote Virtualization, Infinite Scroll and Remote paging are demonstrated along with code-snippets and live demos.
Having said this, these demos use an example remote data source (the classic Northwind database), which is configured to serve data on chunks. This is a common practice when the data is huge and serving it all at once would come to the detriment of performance and memory. For the purposes of the example, the Northwind server processes query parameters from the request URL to determine the data portion to serve, as well as any additional arguments, such as sorting or filtering.
Since your concern is essentially the same, I would suggest considering implementing such a backend service that allows fetching data on chunks in an effort to implement remote virtualization and in this way not to introduce a bottleneck point in your app.
However, as mentioned, please, keep in mind that implementing such a service is out of the scope of Infragistics Support, as it is not related to our UI components. As to what concenrs them, they offer a versatile API to support these remote data operations.
If you require any assistance with the IgxGrid usage, please, let me know.
Best regards, Bozhidara Pachilova