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.