Hi!
Don't know if I does not understand this or...?
Using VS2003 , fbConnection and fbDataAdapter in design time.
1.. creating one fbConnection, OK!
2.. creating one fbDataAdapter with sql text, OK!
3.. generating one dataset, OK!
4.. creating one more fbDataAdapter with sql text,
Hello:
1. Andre needs to find a fix or workaround to this specific problem.
2. We need to identify if there is indeed a bug in the provider and/or
Firebird.
At the moment, the responses seem to be mainly aimed at point 1. But
if we find a workaround by using parameterized queries or whateve
Hello:
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 ;-)
H could you send an example of code using sp, please ?
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 "work aro
The "work around" using a parameterized query seems to work. I changed
it and now it is happily running without the extraordinary memory
consumption. However firebird.exe CPU is at 100% and inserting the data
is dead slow. I will run some additional tests to see if I can identify
the source of
Hi
I think we've got two conflicting issues here and both need to be
addressed.
1. Andre needs to find a fix or workaround to this specific problem.
2. We need to identify if there is indeed a bug in the provider and/or
Firebird.
At the moment, the responses seem to be mainly aimed at point
Andre Wrote:
I used "multiple
commands". My first thought was to call the dispose as well. So I did, but
it did not change the behaviour on the server side.
I will try the prepare and see if anything changes. Maybe I did not understand
the on-line help and I am doing somethin
Hello:
Try to use parametrized command instead of generating new sql
statement in loop.
I have met this before when I have assigned in loop new CommandText.
It seems that the previous statements are left unprepared by Firebird.
I don't know whether it is feature of Firebird or the provider.
Hi,
Try to use parametrized command instead of generating
new sql statement in loop.
I have met this before when I have assigned in loop new
CommandText. It seems that the previous statements are left unprepared
by Firebird. I don't know whether it is feature of Firebird or the
provider.
I used "multiple commands". My first thought was to call the dispose as
well. So I did, but it did not change the behaviour on the server side.
I will try the prepare and see if anything changes. Maybe I did not
understand the on-line help and I am doing something wrong.
Another side effect i
Hello:
I am using an explicit transaction. I tried to insert all data using
one transaction and I tried to commit after each insert.
Are you using "multiple commands" to do the inserts or a single one that
is prepared ??
If you are using "multiple commands" are you calling Dispose ??
Can y
11 matches
Mail list logo
