Subject Re: [firebird-support] Re: Firebird Usage Load Problem
Author David Johnson
> 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.