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

re things you can do optimize the .NET loops. Thank you, Edward Mendez From: Alexander Muylaert-Gelein [mailto:amuylaert_gel...@hotmail.com] Sent: Friday, August 8, 2014 1:54 AM To: firebird-net-provider@lists.sourceforge. Subject: Re: [Firebird-net-provider] Questions with performanc

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

pendent IT Specialist From: Paulo Gomes 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

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

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 for each r

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 keep

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

-net-provider@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 ga

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

me. 18 seconds... I'm 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

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

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 o

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

: Alexander Muylaert-Gelein [mailto:amuylaert_gel...@hotmail.com] Sent: Friday, 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 delph

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

t; > Date: Fri, 8 Aug 2014 09: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, > >

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

ura [mailto:disk...@cincura.net] > > Sent: Friday, August 8, 2014 1:59 AM > > 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, > &

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

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

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

Aug 2014 18:14:43 -0400 Subject: 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

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 appli