Topic
  • 1 reply
  • Latest Post - ‏2014-01-22T15:26:27Z by LukeNumrych
Yurgen
Yurgen
1 Post

Pinned topic What is the fastest way to insert 1 mln+ records in DB2 table from .NET?

‏2014-01-22T14:00:03Z | insert performance

What is the fastest way to insert 1 mln+ records in DB2 table from .NET?

I've check several way and the fastest is by 1000 rows basing on the following request: INSERT INTO tbl (id, rel) values (1, 2), (2,3),...

  • LukeNumrych
    LukeNumrych
    118 Posts

    Re: What is the fastest way to insert 1 mln+ records in DB2 table from .NET?

    ‏2014-01-22T15:26:27Z  

    Take a look at DB2BulkCopy Class, this may be what you are looking for.