From: Mark R. <ma...@la...> - 2018-09-16 08:49:17
|
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 |