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

2014-08-08 Thread Jiří Činčura
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

[Firebird-net-provider] Abbility to use no garbage collect connection parameter

2014-08-08 Thread Lukáš Vykydal
Hi i d'like to add support for option NoGarbageCollect to connection parameters. I purpouse this implementation: - Connection String will be extended with parameter no garbage collect (synonym: nogarbagecollect) - Connection String Builder will be extended eigher (.NET property -

Re: [Firebird-net-provider] Abbility to use no garbage collect connection parameter

2014-08-08 Thread Jiří Činčura
Looks fine to me. -- Mgr. Jiří Činčura Independent IT Specialist -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight -

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

2014-08-08 Thread Edward Mendez
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: Jiří Činčura [mailto:disk...@cincura.net] Sent: Friday, August 8, 2014 1:59 AM To: For users and developers of the

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

2014-08-08 Thread Alexander Muylaert-Gelein
I personally really like the one from red-gate but the visual studio profiler is also good. a From: emendez...@nc.rr.com To: firebird-net-provider@lists.sourceforge.net Date: Fri, 8 Aug 2014 09:51:52 -0400 Subject: Re: [Firebird-net-provider] Questions with performance metrics doing

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

2014-08-08 Thread Jiří Činčura
Yep, same for me. -- Mgr. Jiří Činčura Independent IT Specialist From: Alexander Muylaert-Gelein [mailto:amuylaert_gel...@hotmail.com] Sent: Friday, August 8, 2014 8:55 PM To: firebird-net-provider@lists.sourceforge. Subject: Re: [Firebird-net-provider] Questions with performance metrics doing

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

2014-08-08 Thread Edward Mendez
Alexander, Thank you for the feedback. Two more things... 1. Your transaction parameters please. How do you create them, what settings? 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

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

2014-08-08 Thread Jiří Činčura
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

2014-08-08 Thread Edward Mendez
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