[Firebird-net-provider] [FB-Tracker] Created: (DNET-1041) FbBulkCopy class for faster import

[Baldur F. (J. <tr...@fi...>]

FbBulkCopy class for faster import
----------------------------------

                 Key: DNET-1041
                 URL: http://tracker.firebirdsql.org/browse/DNET-1041
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 8.0.1.0
         Environment: Windows 10, Firebird any version, I7 2.6GHz, 16GB Memory
            Reporter: Baldur Fürchau
            Assignee: Jiri Cincura
            Priority: Minor
         Attachments: FbBulkCopy.cs

I have developed a class FbBulkCopy, similar the SqlBulkCopy. I can't reach the speed of SQL-Server, but with less columns and small records the speed is good.

I create an execute block (p1...pn) with many insert into table (:p1...:pn); end;

Restrictions are: The size of parameters must be within recordsize 64K, the size of block must be less 64k.
But, for example, an insert with 8 columns speeds up from 8000 to 22.500.

Where  can i send/upload my class, so you can check this if it can be used for Firebird client?
Some fieldtypes must be added.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira