Re: [Firebird-net-provider] Error reading data from the connection

[Mark R. <ma...@la...>]

You are posting to the old list. The list has moved to Google Groups.

Subscribe by sending a mail to:
fir...@go...

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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 


-- 
Mark Rotteveel