Hi,
Your shot in the dark hit the target.
I do not have a commit after the insert.
The problem is I never do "BeginTransaction" in my program. So I don't
have the option to commit as far as I understand.
If I look at the FbConnection object, I see that the activeTransaction
is always null.

1) Is there a way to tell the Database to commit itself after a certain
number of INSERTs?
2) Is it ok to commit the transaction after every INSERT, or will it
create a performance problem for the INSERT?
What am I doing wrong???? (I know I am doing something wrong but I can't
find any good esplanation about using transactions in firebird )

Thanks for your help,
Ariel Sakin


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Si Carter
Sent: Tuesday, November 15, 2005 12:20 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Some performance problems.

> -----Original Message-----
> How can the fact that I just inserted the rows to the
> database affect the time it take to query the table?
>
> Why is it so much faster after I re-open the connection to
> the database??

A shot in the dark, are you committing the transaction after inserting
all
your records?

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links