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... Are you su
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 Expre
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
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
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 (o
d-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!
>> Ju
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
pro
Hi all,
I'm trying to do the following:
a- Start a transaction
b- Alter a table adding a new field
c- Set a new value to the new field for all the registers in the table
d- Commit
c) fails because it "can't see" the newly added field. I have to commit
between b) and c).
Is this correct? Is the
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 G
Hi,
I've detected the following problem in Solaris with version 1.7.1.0. I'm
using mono 1.2.4.
When you read a char field of lenght 1, Windows and Linux return a char of 1
but in Solaris you get a string with the value and 2 blanks.
Pablo
Well, we have run our internal tests, and also the profiler, and changing
this code gains 20%, so it doesn't seem to be doing exactly the same. The
"old" code running through the switch several times, and creating an
encoding object thousands of times too.
Our tests run our Plastic SCM system f
g
instances for all charsets.
This could be a problem wehen working with the compact framework.
Maybe i can try to do the change (for the 2.1.0 sources) using
conditional code
- Original Message -
From: "pablosantosluac" <[EMAIL PROTECTED]>
To: "Carlos Guzmán Á
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 b
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"
Sent: Monday, December 18, 2006 1:48 PM
Subject: Re: [Firebird-
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 develop
well, I actually never got it to run, it crashed due to threading
problems... and I don't even know about 2.0
- Original Message -
From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
Sent: Sunday, December 17, 2006 10:33 AM
Sub
Hi all,
Well, I regularly ask the same question but... is there any progress on
Firebird/Mono Embedded on Linux?
Regards,
pablo
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel a
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" <
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
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:
StackTrace " at FirebirdSql.Data.Common.IscHelper.VaxInteger(Byte[]
buffer, Int32 index, Int32 length)\r\n at
FirebirdSql.Data.Comm
1.7.0.1
- Original Message -
From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
Sent: Friday, August 25, 2006 5:18 PM
Subject: Re: [Firebird-net-provider] Problems setting the charset to a new
database
Hello:
> We are using
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
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
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"
Sent: Monday, August 21
RIMARY KEY (iobjid);
- Original Message -
From: "Jiri Cincura" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
Sent: Monday, August 21, 2006 9:24 AM
Subject: Re: [Firebird-net-provider] Problems with FbBatchExecution
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
Hi all,
Is it possible to use firebird embedded on Linux, with mono, and
multithreading? Last time we tried (last November as far as I remember), it
was not possible to embed on Linux, mono crashed inmediately with a thread
problem... Has anyone tried?
And another issue: we had much lower p
Hi,
We are using firebird embedded in a heavy-multithreaded application, and it
works great... on windows... no way to make it work on Linux
- Original Message -
From: "Andrew" <[EMAIL PROTECTED]>
To:
Sent: Friday, August 04, 2006 4:20 PM
Subject: [Firebird-net-provider] Multithreading
Hello,
I would like to read/write data from a blob in a
Firebird table, but in chunks.
AFAIK I could read this way using FbDataReader
GetBytes but... Is there a way to write in that way too?
It seems there is something similar in SQLServer
(http://msdn.microsoft.com/library/default.asp?
29 matches
Mail list logo
