New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Bulk Insert into multiple tables concurrently #180

Closed

manojkumaraut opened this issue May 2, 2019 · 1 comment

Labels

manojkumaraut commented May 2, 2019

Hi Team,
Is there any way to bulk Insert into multiple tables concurrently using EFCore.BulkExtensions?

Thanks and appreciate your help

Owner

borisdj commented May 2, 2019 •

edited

Loading

I haven't tested concurrently Inserts.
But you can try it, more info here:
https://www.adathedev.co.uk/2011/01/sqlbulkcopy-to-sql-server-in-parallel.html
And it seems that this can be done only into an unindexed table:
Importing Data in Parallel with Table Level Locking

Also deadlock can be an issue:
deadlock-when-using-sqlbulkcopy-to-concurrently-insert-rows-into-a-single-nonempty-table
Useful info: #46

borisdj added the question label

borisdj closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment