Bulk inserts taking longer than expected using Dapper

by

The best I was able to achieve was 50k records in 4 seconds using this approach

SqlTransaction trans = connection.BeginTransaction();

connection.Execute(@"
insert Member(Username, IsActive)
values(@Username, @IsActive)", members, transaction: trans);

trans.Commit();

More Related Contents:

  1. High-performance merging of ordered sets
  2. Google app script timeout ~ 5 minutes?
  3. What is the best approach to encapsulate blocking I/O in future-rs?
  4. Why does breaking the “output dependency” of LZCNT matter?
  5. What is the purpose of the EBP frame pointer register?
  6. Algorithm to calculate the number of divisors of a given number
  7. Why are difference lists more efficient than regular concatenation in Haskell?
  8. Analyzing Code for Efficiency?
  9. Apache Spark: map vs mapPartitions?
  10. Reading GHC Core
  11. CSS3 Transitions: Is “transition: all” slower than “transition: x”?
  12. Size of store buffers on Intel hardware? What exactly is a store buffer?
  13. Avoid stalling pipeline by calculating conditional early
  14. Timing JavaFX Canvas Application
  15. What’s the fastest way to merge/join data.frames in R?
  16. How to optimize vlookup for high search count ? (alternatives to VLOOKUP)
  17. Android studio takes too much memory
  18. Most efficient list to data.frame method?
  19. Tools to measure MPI communication costs [closed]
  20. Has anyone actually implemented a Fibonacci-Heap efficiently?
  21. Order of the code and performance
  22. Why are compilers so stupid?
  23. SVN performance after many revisions
  24. In SQLite, do prepared statements really improve performance?
  25. Mapping 2 vectors – help to vectorize
  26. MongoDB ranged pagination
  27. Why is appending to a list bad?
  28. Why is putImageData so slow?
  29. Why does the Execution Plan include a user-defined function call for a computed column that is persisted?
  30. Network throttling with chrome and selenium

Leave a Comment