Performance issue with Insert\Update records #526

vishalnikam created 3 years ago

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&lt;QuoteInvoiceDetailCreateDto, QuoteInvoiceDetail&gt;(quoteInvoice);
                newQuoteInvoice.QuoteId = quote.Id;
                await _quoteInvoiceDetailRepository.InsertAsync(newQuoteInvoice);
            }
            await CurrentUnitOfWork.SaveChangesAsync();

1 Answer(s)