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

[Jiří Č. <di...@ci...>]

> 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 of hand really quickly.

> I read somewhere that Looping in .NET is somewhat slower than in Delphi, 
> but there are things you can do optimize the .NET loops. 

I would rather write correct algorithm than spent hours on micro-optimizing loops. BTW did you know asm loops are faster than Delphi and .NET loops?

-- 
Mgr. Jiří Činčura
Independent IT Specialist