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 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
