Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-21 Thread Dean Harding
Steve Miller wrote: >> well, you know, it depends on the test, but I can tell you that I'm getting >> much better results out of SQL Server right now, but I'm working on this, my >> intention is having a fb backend much faster than anything else... and yes, >> I didn't see any different from Exp

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-21 Thread Steve Miller
> well, you know, it depends on the test, but I can tell you that I'm getting > much better results out of SQL Server right now, but I'm working on this, my > intention is having a fb backend much faster than anything else... and yes, > I didn't see any different from Express or no-express... A

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-20 Thread pablosantosluac
ress... Are you sure it only uses one processor? - Original Message - From: "Steve Miller" <[EMAIL PROTECTED]> To: "For users and developers of the Firebird .NET providers" Sent: Wednesday, January 16, 2008 5:54 PM Subject: Re: [Firebird-net-provider] Firebird s

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-16 Thread Steve Miller
> Well, needless to say I'm pretty happy with Firebird, which I believe is a > great db. In fact up to 10 concurrent users (I'm talking about our system, > it will obviously vary with others) Fb is better than SQL Server. > > > Well, I tried both with SQLServer 2005 (a developers' release) and

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-15 Thread pablosantosluac
quot;For users and developers of the Firebird .NET providers" Sent: Tuesday, January 15, 2008 7:24 PM Subject: Re: [Firebird-net-provider] Firebird scalability under heavy load > Hi Pablo, > > Thank you for publishing your numbers. > >> On the other hand, in my test, the em

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-15 Thread Steve Miller
Hi Pablo, Thank you for publishing your numbers. > On the other hand, in my test, the embedded server is slower than the > "external" one: 444s to complete the embedded vs 291 the "external". > Just to give some data to compare: using SQL Server the same test > (exactly the same code base) req

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-14 Thread Carlos
Hello: > Ok, the first two methods (Fetch & Free) eat about 26% of the test time > and they're basically spending their times at FbClient.isc_dsql_fetch and > FbClient.isc_dsql_free_statement. > Maybe the problem could be in the fact the fetches are done with only one record in each time, whi

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-14 Thread Jiri Cincura
On 1/14/08, pablosantosluac <[EMAIL PROTECTED]> wrote: > Hi, > > Is there a place where I can find a performance benchmark comparing Firebird > with other dbs?? Probably yes. But better to ask in support list. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http:

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-14 Thread pablosantosluac
2008 10:11 PM Subject: Re: [Firebird-net-provider] Firebird scalability under heavy load > On 1/13/08, pablosantosluac <[EMAIL PROTECTED]> wrote: >> On the other hand, in my test, the embedded server is slower than the >> "external" one: 444s to complete the embed

Re: [Firebird-net-provider] Firebird scalability under heavy load

2008-01-13 Thread Jiri Cincura
On 1/13/08, pablosantosluac <[EMAIL PROTECTED]> wrote: > On the other hand, in my test, the embedded server is slower than the > "external" one: 444s to complete the embedded vs 291 the "external". Just to > give some data to compare: using SQL Server the same test (exactly the same > code ba

Re: [Firebird-net-provider] Firebird scalability under heavy load

2007-12-28 Thread Carlos
Hello: Ok, so, you mean I should try with the new 2.0+ provider? I mean, we are > having the same problems with the "server" (not the > embedded one). > Well no, it maybe a problem on it, but we may try to check where is the problem ( the 2.0+ has performance changes on other areas as well, b

Re: [Firebird-net-provider] Firebird scalability under heavy load

2007-12-28 Thread pablosantosluac
as we do using SQL Server. pablo - Original Message - From: Carlos To: For users and developers of the Firebird .NET providers Sent: Friday, December 28, 2007 10:47 AM Subject: Re: [Firebird-net-provider] Firebird scalability under heavy load Hello: We have to cont

Re: [Firebird-net-provider] Firebird scalability under heavy load

2007-12-28 Thread Carlos
Hello: We have to continue using .NET 1.1 that's why we didn't move to a newer > provider. > Ok, it maybe a provider problem, in version 2.0+ there are several changes in the embedded server support some of them to solver performance problems ( that if i remember well they are not applied to 1.7

Re: [Firebird-net-provider] Firebird scalability under heavy load

2007-12-28 Thread pablosantosluac
.NET providers Sent: Friday, December 28, 2007 8:23 AM Subject: Re: [Firebird-net-provider] Firebird scalability under heavy load Hello: 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

Re: [Firebird-net-provider] Firebird scalability under heavy load

2007-12-28 Thread pablosantosluac
ost 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" Sent: Friday, December 28, 2007 4:36 AM Subject: Re: [Firebir

Re: [Firebird-net-provider] Firebird scalability under heavy load

2007-12-27 Thread Carlos
Hello: 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. As Dean has stated yet without a little more of information ti's going to be hard to help ... What version of Fir

Re: [Firebird-net-provider] Firebird scalability under heavy load

2007-12-27 Thread Dean Harding
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 ru