[Kinterbasdb-help] Why is kinterbasdb so slow?

[Yasushi I. <ya...@ra...>]

kinterbasdb is 20 times slower than gvib. Why is kinterbasdb so slow?

kinterbasdb:

  $ time ./bench.py

  real    166m43.947s
  user    0m2.870s
  sys     0m2.360s

gvib:

  $ time ./bench.py

  real    7m35.217s
  user    0m42.360s
  sys     0m12.490s

My System is:

Pentium III 650MHz, 256MB RAM

Red Hat Linux 7.3(kernel 2.4.18)
Python 2.1.3
FirebirdSS 1.0.0
kinterbasdb 3.0
GV Interbase Database Adapter(gvib) 0.9.6
  http://www.zope.org/Members/bkc/gvibDA

----

#!/usr/bin/env python2.1
"""
bench.py
"""

import sys, kinterbasdb
database = kinterbasdb

# import sys, gvib
# database = gvib

from os.path import basename

def main():
    for i in range(10000):
        try:
            db = database..connect(dsn='127.0.0.1:/home/ib/bench.gdb', user='foo', password='foo')
	    # db = database.connect('127.0.0.1:/home/ib/bench.gdb', 'foo', 'foo')
        except:
            sys.stderr.write("%s: Cannot connect Database Server.\n"
                             % basename(sys.argv[0]))
            raise
        cursor = db.cursor()
        sql = "INSERT INTO FOO VALUES(GEN_ID(GEN_FOO_ID, 1), '%d')" % i
        try:
            cursor.execute(sql)
        except:
            db.rollback()
            sys.stderr.write('%s: Database Insert Error: %s'
                             % (basename(sys.argv[0]), sql))
            raise

        db.commit()
        cursor.close()
        db.close()

if __name__ == '__main__':
    main()