Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB

2014-08-09 Thread Alexander Muylaert-Gelein
Hi Attached some examples of transactions properly set. If you can put the reader in readonly and the writer in WriteNoUndo, you gain some speed. But euh, no magic to expect here. It might be interesting to profile it though and post the results back. public static class Transaction {

Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB

2014-08-09 Thread Norbert Saint Georges
Hello there, can you send me your delphi dotnet project and I can understand what takes 18 seconds-) I D1, D3, D5, D7 VS2005- VS2013. I develop mainly in DotNet (RemObjects) and just so happens that, in normal use, dotnet is better than an application server delphi Norbert Saint

Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB

2014-08-09 Thread Paulo Gomes
Hi Edward, I think you answered yourself, the enumerator uses a trip to the database for each record. You should try to break the data in smaller packages (10 for example) and use a DataAdapter to get the data into DataTable. If possible also use several transactions (1 per Package) to