--- In firebird-support@yahoogroups.com, David Johnson
<johnson_d@c...> wrote:

>
> > What I did is this (python codes):
> >
> > import kinterbasdb
> > connection = kinterbasdb.connect(<connection string>)
> > cursor = connection.cursor()
> > # inserting data for example
> > for line in data:
> > cursor.execute(<sql statement>)
> > cursor.commit()
> >
> > # when i'm done
> > cursor.commit() # final commit, just in case
> > cursor.close()
> > connection.close()
> >
>
> So you are committing after every row that you process. This will slow
> you down enormously. Try committing every 5000 rows.

That seems to help a good bit. Will be tracking on this.

Thanks Maurice