ralmsdeveloper / EntityFrameworkCore.FirebirdSQL

FirebirdSQL database provider for Entity Framework Core.
Other
44 stars 26 forks source link

[NOT-AN-ISSUES-ONLY-QUESTION] ;-) #30

Closed newdeal30 closed 6 years ago

newdeal30 commented 6 years ago

Hi!,

One question: How is bulk insert done? Do you mean the DbContext.AddRange() function? Thanks and regards Michael

ralmsdeveloper commented 6 years ago

Hello @newdeal30, Exactly, however I removed the bulk insert in version 2.1-Preview, I'm working on improvements to 2.1.

I had some bad experiences, so I decided to refactor this.

newdeal30 commented 6 years ago

Thanks for your quickest response ;-) I am currently using V2.0.11.6. Is it working there? What would you do to get faster inserts? All in one seperate Transaction? Thanks and regards Michael

ralmsdeveloper commented 6 years ago

A 2.0.11.x supports batching. This is using the EXECUTE BLOCK, to have more performance and send in bulk!

newdeal30 commented 6 years ago

Thanks!