Performance issue.
I changed my code from using stored procedures to a simple SQL insert
and now the performance is living up to my expectations. Inserting the
16.000+ rows now takes a mere 22 seconds. Still a tad slow, but it is a
start ;-)
André
Jager
André Jager wrote:
The "
er did not help me to see what is going on in the
firebird server. I used the fb_lock _print utility but interpreting the
outcome of this program is rather a challenge.
André
Jager
Mike Scott wrote:
Hi
I think we've got two conflicting issues here and both need to be
addressed.
1.
FirebirdSql.Data.Firebird.FbCommand cm =
new FirebirdSql.Data.Firebird.FbCommand(
Command, c.Connection, t
);
cm.ExecuteNonQuery();
.
.
.
André
Jager
Carlos Guzmán Álvarez wrote:
Hello:
I
I am using an explicit transaction. I tried to insert all data using
one transaction and I tried to commit after each insert.
André
Jager
Ruben Guinez wrote:
When you do insert, are you use default transaction?, o
explicit transaction?
On 10/31/05, André Jager <[EMAIL PROTEC
(4294967295).
At first I thought it was a Firebird problem, but after spending a few
hours with this problem, I think it is a .Net provider bug.
I am looking for sugestions on how to proceed to find out if it is a
.Net provider problem and how to pin down the bug.
thanks,
André
Jager
t the source
(GdsTransaction.cs) and found no evidence of two phase commit support.
Can I have a confirmation on this issue. Will support be added? Or did
I overlook something.
thanks,
André
Jager