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

...@sapo.pt Sent: Saturday, August 09, 2014 4:30:41 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Hi Edward, I think you answered yourself, the enumerator uses a trip to the database

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

: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB It's roundtrip per some records (depends on size of data), not each record. Putting the records into DataTable will not be faster in any way, as it uses the DataReader internally. -- Mgr. Jiří Činčura

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

: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB 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

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

interested in speeding things up then :-) thanks a From: emendez...@nc.rr.com To: firebird-net-provider@lists.sourceforge.net Date: Fri, 8 Aug 2014 09:41:03 -0400 Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Alexander, Thank you for the feedback

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

@lists.sourceforge. Objet : Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB 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

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

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

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

Hi, Any chance to do profiling? I would expect .NET be slightly slower that .NET, but this is x-times slower. That's weird. But finding the bottleneck might be helpful. -- Mgr. Jiří Činčura Independent IT Specialist

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

of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Hi, Any chance to do profiling? I would expect .NET be slightly slower that .NET, but this is x-times slower. That's weird. But finding the bottleneck might be helpful

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

To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Hi, Any chance to do profiling? I would expect .NET be slightly slower that .NET, but this is x-times slower. That's weird

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

:51:52 -0400 Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Jiri, I am not familiar with Profiling. Is there one that you can recommend? Thank you, Edward Mendez Also, are there any tests that I can -Original Message- From

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

, August 8, 2014 1:54 AM To: firebird-net-provider@lists.sourceforge. Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Hi Edward I'm also coming from a delphi background (using FIB) and we have ported/are already porting for 5 years our

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

To be honest I’ve never really thought about the transaction settings other than the default. Are there a specific settings I should be using for just reading “stale” data? You should start transaction explicitly. Else it's one transaction per command and in a batch processing that goes out

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

You should start transaction explicitly. Else it's one transaction per command and in a batch processing that goes out of hand really quickly. I agree with you 100%. The part that I hadn't given much thought was the Isolation levels to pass as the parameter into the transaction object. I

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

Hello All, I have to develop an application that will move old/stale data from certain tables to another FB DB. We already have an existing application that did something similar to this, but his application is written using Delphi 5 and we are a .NET shop and wanted to develop newer

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

with performance metrics doing large inserts into DB Hello All, I have to develop an application that will move old/stale data from certain tables to another FB DB. We already have an existing application that did something similar to this, but his application is written using Delphi 5 and we