Comments (9)
Hello @premsai ,
Is it possible to get your SQL Table definition, including index and trigger? You can send it in private here: [email protected]
It will be easier for us to give you a better answer with those informations as 1h30 for only 5 million looks very slow at first sight.
Best Regards,
Jon
from dapper-plus.
Hello @premsai
Since our last conversation, we haven't heard from you.
Don't hesitate to contact us if you need further information.
Best regards,
Jon
from dapper-plus.
from dapper-plus.
Hello @premsai ,
Thank you for the additional information.
This is what I expected, your table has hundreds of columns, which explains why this is long.
In your case, one thing to make sure of is that the SqlBulkCopy
is executed directly in the destination table and not your temporary table, as it will make the operations way longer otherwise.
By making sure the SqlBulkCopy
is executed in the destination table, you will gain a performance increase. However, you will not be able to output values such as the identity
value.
So all options such as specifying the identity must be removed (you can specify it as a key instead).
See the following example: https://dotnetfiddle.net/bdiM7D , you will see in the log returned the following line:
SqlBulkCopy: [Invoice]
-- BulkCopyTimeout:120
So in this case, we know that the SqlBulkCopy
has been done in the destination table [Invoice]
.
Let me know if you see any performance gains or if the SqlBulkCopy
was already made in the destination table.
Best Regards,
Jon
from dapper-plus.
from dapper-plus.
Hello @premsai,
Since our last conversation, we haven't heard form you.
How if your evaluation going?
Let me know if you need further assistance.
Best regards,
Jon
from dapper-plus.
from dapper-plus.
Hello @premsai,
Sure! You can contact us directly at [email protected]
I will be able to assist you with any questions or concerns.
Best regards,
Jon
from dapper-plus.
from dapper-plus.
Related Issues (20)
- A transport-level error for NVarchar(max) column when using auditing HOT 7
- Received an invalid column length from the bcp client for colid HOT 3
- Set ColumnSynchronizeDeleteKeySubsetExpression without .Entity<Whatever>()? HOT 4
- IndexOutOfRangeException on BulkMerge operations HOT 1
- ILogger not logging, but Console.WriteLine works? HOT 3
- Configure Merge for concurrency handling HOT 3
- Ids not coming back after first BulkInsert HOT 4
- Update trigger on target table causes BulkMerge to fail HOT 3
- Feature Request - suppress update if nothing changed. HOT 2
- BulkInsert doesn't generate primary key for multiple concurrent submission HOT 7
- Support for Sybase for Bulk Insert HOT 1
- Skip duplicate records on bulk insert HOT 5
- Avoid output HOT 7
- BulkInsert Postgres => An error occured while retrieving the InformationSchemaTable information. See the inner exception for details. HOT 4
- Dapper Plus can't map Id when use galera cluster HOT 3
- bulk insert very slow on mariadb version≥10.6.0 HOT 2
- PostgreSQL BulkMerge / BulkUpdate always returns all rows as update HOT 6
- Bulk Insert throws the exception 'Unknown data type' whenever inserting GUID to MySQL HOT 4
- Does this support DateOnly/TimeOnly? HOT 6
- Does this support Aot HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dapper-plus.