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();
Markdown supported.
Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

1 Answer(s)
  • User Avatar
    0
    liangshiwei created
    Fullstack Developer

    Hi,

    You can use entityframework-plus.

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v10.8.0-preview. Updated on September 16, 2026, 14:50
1
ABP Assistant
🔐 You need to be logged in to use the chatbot. Please log in first.