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
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
