Bulk-Operations

Bulk-Operations copied to clipboard

BulkInsert issue with changing database schema

11

Hey all, I'm using `BulkInsertAsync` in parallel with different / changing table schemas. I run in to some problems because the framework caches the table schema. I found the following...

riedd2

Setting the join indicator in BulkMerge method

5

Hi , to avoid the constraint issues, could I set the **join indicators** for BulkMerge method? just like in the following merge query, I will get some exceptions: e.g. _Cannot...

Song-s-z

Problems with Postgres Database and TimeSpan

3

I am trying bulk insertion from datatable which contains timespan columns. On insertion to database, while using bulk operation, the following error occurs 

rajkamal0610

Setting timeout on DeleteFromQuery

4

Hi, is there a way to override the default timeout of the DeleteFromQuery operation? I couldn't find anything in the documentation. Thanks

fayilt

Help on slow performance in postgres

9

500k records 30 columns insertion taking 40sec 5M records 15 columns insertion taking 2.5Mins 10M records 30columns insertion taking 16Mins Is there a way to fasten the performance. Hint: We...

rajkamal0610

Performance issues with large datasets when using BulkSynchronize (DELETE issue)

8

Hi, We have come across some issues when using Bulk Synchonize with large datasets. Our destination table is currently at around 120 million rows and we are syncing about 2.4...

CuinnWylie

Double.MinValue insertion into MySQL DOUBLE column

4

When inserting Double.MinValue from VB.NET into a MySQL (8.X or 9.3) DOUBLE column (X), the operation fails with: `Out of range value for column 'X' at row N` **Details:** -...

mpriala-code

Error with BLOB column

4

When performing a BulkInsert into a MySQL (8.X and 9.3) table with a BLOB column (SNAPSHOT) from a VB.NET Byte() column, the operation fails with the error: `Cannot convert string...

mpriala-code