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

2008-01-15 Thread pablosantosluac
Hi, 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-14 Thread pablosantosluac
, January 13, 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 embedded vs 291 the external. Just

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

2007-12-28 Thread pablosantosluac
: [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

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

2007-12-28 Thread pablosantosluac
Hi Carlos, I'll try to run again the test profiling the Firebird provider. We're using 2.0 embedded, but same results with 2.0 (in fact the lastest 2 available) server. We're running with both .NET 1.1 and Mono 1.x profile. We're still using the old 1.7.1 provider with the charset fix (one

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

2007-12-28 Thread pablosantosluac
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). Our intention is to continue using Firebird as our primary target database, so we'll really like to outperform other SCM systems using Fb as we do using SQL

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

2007-12-27 Thread pablosantosluac
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. I guess the problem could be in Fb itself, but I wonder if it could be a

Re: [Firebird-net-provider] Possible bug in Solaris

2007-08-15 Thread pablosantosluac
Hola :-) Well, the server is located on Windows (firebird 2.0). The database encoding is UNICODE_FSS. And we use the same encoding on the connection string. Ok, and another question: is the Firebird 2.0 server available for solaris? Thanks, pablo - Original Message - From: Carlos

[Firebird-net-provider] Big performance gain on Charset.cs

2007-04-16 Thread pablosantosluac
Hi all, We are heavily relying on Firebird for our version control product, Plastic SCM, and we have just found a big performance boost making a small change on Charset.cs. On our tests we have reduced overall time around 20% just changing the following on Charset.cs, so we thought you might

Re: [Firebird-net-provider] Firebird 2.0 Embedded on Linux

2006-12-19 Thread pablosantosluac
anyway, you think synchronizing access would be the solution? - Original Message - From: pablosantosluac [EMAIL PROTECTED] To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Sent: Monday, December 18, 2006 1:48 PM Subject: Re

Re: [Firebird-net-provider] Firebird 2.0 Embedded on Linux

2006-12-18 Thread pablosantosluac
Ok, problem then is thread safety. This was exactly the problem I had on Linux. Is there a way to solve it apart from synchronizing calls? I guess only one DB operation could be active at a time... - Original Message - From: Helen Borrie [EMAIL PROTECTED] To: For users and developers

Re: [Firebird-net-provider] Still problems with Firebird 2.0 and .NET 1.1

2006-10-13 Thread pablosantosluac
Hi again Carlos, As Rubén said earlier today, we can't make the provider work with Firebird 2.0. We can now compile, but no way to run it correctly? Is there anything missing from the CVS? Is it really a fixed problem? Thanks, pablo - Original Message - From: Carlos Guzmán Álvarez

[Firebird-net-provider] Still problems with Firebird 2.0 and .NET 1.1

2006-10-11 Thread pablosantosluac
Hi all, When trying to connect to firebird 2.0 RC5 Embedded mode (with the version 15.3 works ok) and the .NET provider 1.7.1, I get the following exception: StackTraceat FirebirdSql.Data.Common.IscHelper.VaxInteger(Byte[] buffer, Int32 index, Int32 length)\r\n at

Re: [Firebird-net-provider] Still problems with Firebird 2.0 and .NET 1.1

2006-10-11 Thread pablosantosluac
We downloaded again the code but... now we can't compile. [csc] c:\Documents and Settings\ruben.CODICE\Escritorio\Firebird\cvs\NETProvider\NETProvider_17\source\FirebirdSql .Data.Embedded\FesStatement.cs(324,17): error CS1501: Ninguna sobrecarga para el método 'MarshalManagedToNative' adquier

[Firebird-net-provider] Problems setting the charset to a new database

2006-08-25 Thread pablosantosluac
Hi all, I need to create a database with a given Charset. Then I use the following: FbConnection.CreateDatabase(connString, 4096, false, false); where connString is @ServerType=1;User=SYSDBA;Password=masterkey;Database=database.fdb;Pooling=true;Charset=UNICODE_FSS; We are using the embedded

Re: [Firebird-net-provider] Problems setting the charset to a new database

2006-08-25 Thread pablosantosluac
1.7.0.1 - Original Message - From: Carlos Guzmán Álvarez [EMAIL PROTECTED] To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Sent: Friday, August 25, 2006 5:18 PM Subject: Re: [Firebird-net-provider] Problems setting the charset to a

[Firebird-net-provider] Problems with FbBatchExecution

2006-08-21 Thread pablosantosluac
Hi, I'm trying the latest provider with Firebird 2.0 RC4, and I got an IndexOutOfRangeException trying to create some tables. Exactly the same code was working with Firebird 1.5.3... Any idea? - Using Tomcat but need to

Re: [Firebird-net-provider] Problems with FbBatchExecution

2006-08-21 Thread pablosantosluac
On 21.8.2006 8:55 pablosantosluac wrote: Hi, I'm trying the latest provider with Firebird 2.0 RC4, and I got an IndexOutOfRangeException trying to create some tables. Exactly the same code was working with Firebird 1.5.3... Any idea? Any example of code you're using? -- Jiri {x2

Re: [Firebird-net-provider] Problems with FbBatchExecution

2006-08-21 Thread pablosantosluac
Hi Carlos, Well, I already sent some sample code to the list this morning. Do you want me to send a more complete sample? thanks - Original Message - From: Carlos Guzmán Álvarez [EMAIL PROTECTED] To: For users and developers of the Firebird .NET providers

Re: [Firebird-net-provider] Embedded firebird on Linux?

2006-08-21 Thread pablosantosluac
hi, well, it happened almost 9 months ago. They told me it was a threading problem, that probably I should recompile fbembed with the GC threads package... In the email I sent to the mono-list (I think you even added some some points) I told: But on Linux as soon as two clients connects to