You are posting to the old list. The list has moved to Google Groups.
Subscribe by sending a mail to:
firebird-net-provider+subscr...@googlegroups.com
or by visiting
https://groups.google.com/forum/#!forum/firebird-net-provider
Mark
On 16-11-2017 15:33, LtColRDSChauhan wrote:
Hello,
1. I need to frequently copy a table from one database to another. This
has started to fail now, apparently due to increase in number of
records. Attempting to copy about 13,26,000 records fails reporting
“Error reading data from the connection”. Number of records that I can
still successful copy is about 13,24,510.
3. I copy the in batches of 50,000 records (variable) each. For each
batch, i open and close connection. I have tried setting connection
pooling true and false both. Also varied the batch size to 5000, 100000 etc.
2. My database and client are on the same machine. Other details:
RAM 16 GB
Client application 64 Bit
OS Windows 10 64 Bit
Firebird ADO.NET <http://ADO.NET> Data Provider – tried both: 5.11.0.0
and 5.12.0
Firebird 3.0.2.32703_0_Win64
3. Please suggest possible solutions.
Regards,
Rajiv
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Mark Rotteveel
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider