Hi there,
Plastic is www.plasticscm.com. I didn't try with isql, I would need to run several queries in parallel to actually know whether the problem is the provider or not. What I wanted to know is whether you've profiled it under concurrent access or not. Locking should be the most likely one to blame here, but you never know until you try it... pablo ----- Original Message ----- From: "Dean Harding" <[EMAIL PROTECTED]> To: "For users and developers of the Firebird .NET providers" <firebird-net-provider@lists.sourceforge.net> Sent: Friday, December 28, 2007 4:36 AM Subject: Re: [Firebird-net-provider] Firebird scalability under heavy load > pablosantosluac wrote: >> Hi there! >> >> I'm running stress tests on Plastic with a Fb backend, and as soon as the >> server starts attending several clients, we've a huge performance hit! >> Just >> configuring plastic to use SQL Server solves the problem. > > Um, what is "plastic"? > >> The thing is: I run a query which takes X seconds to complete. Well, two >> threads doing the same in parallel takes > 2xX which doesn't look like a >> good scalability factor. > > Do you know the queries it is trying to execute? Can you execute them > some other way (e.g. isql). That'll let you figure out if there problem > is in the provider or in the server. > > My psychic powers tell me it's probably something to do with locking in > the server, but without know what the actual queries are, it's hard to > know for sure... > > Dean. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
