Open Closed

Performance issue with Insert\Update records #526


User avatar
0
vishalnikam created

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

  • ABP Framework version: v3.0.4
  • UI type: Angular
  • Tiered (MVC) or Identity Server Seperated (Angular): yes
  • Exception message and stack trace:
  • Steps to reproduce the issue:

Facing Performance issue in with Insert\Update with high volumn of data using PostgrsSQL. CurrentUnitOfWork.SaveChangesAsync() takes much time to respond.

Is there any solution availble in ABP.io framweork to bulk insert/update or should we go with store procedure in PostgrsSQL . Please suggest

            foreach (var quoteInvoice in input.QuoteInvoiceDetails)
            {
                var newQuoteInvoice = ObjectMapper.Map<QuoteInvoiceDetailCreateDto, QuoteInvoiceDetail>(quoteInvoice);
                newQuoteInvoice.QuoteId = quote.Id;
                await _quoteInvoiceDetailRepository.InsertAsync(newQuoteInvoice);
            }
            await CurrentUnitOfWork.SaveChangesAsync();

1 Answer(s)
Made with ❤️ on ABP v9.1.0-preview. Updated on December 05, 2024, 12:19