Subject | Re: [firebird-support] Re: Firebird Usage Load Problem |
---|---|
Author | David Johnson |
Post date | 2005-07-14T23:59:23Z |
> What I did is this (python codes):So you are committing after every row that you process. This will slow
>
> 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()
>
you down enormously. Try committing every 5000 rows.