[firebird-support] Concurreny transaction impact on writers

2013-12-07 Thread zvjezdan77
Hi. In highly concurrent environment, part of an app is using .NET RepeatableRead transaction to read data from few tables. I noticed that during these reads, writers to these tables experience major slowdown. So question is this: Does (Concurrency,ReadWrite) (.NET RepeatableRead) has major impac

[firebird-support] Re: Concurreny transaction impact on writers

2013-12-08 Thread zvjezdan77
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote: > > > Hi. In highly concurrent environment, part of an app is using .NET > > RepeatableRead transaction to read data from few tables. > > I noticed that during these reads, writers to these tables experience major > > slowdown.

[firebird-support] Re: Concurreny transaction impact on writers

2013-12-08 Thread zvjezdan77
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote: > > >>> Hi. In highly concurrent environment, part of an app is using .NET > >>> RepeatableRead transaction to read data from few tables. > >>> I noticed that during these reads, writers to these tables experience > >>> major s

[firebird-support] Server setup advice

2013-12-11 Thread zvjezdan77
Hi. I'm running firebird Firebird-2.5.2.26540_0_x64 superclassic in highly concurent enviroment where I have up to 200 to 500 concurrent connections, most of them from IIS web services. Win server 2008, db and web server on same rig. I'm running it on on Intel X5450 3.00GZ Quad core rig with 8gigs