kinterbasdb-help Mailing List for KInterbasDB

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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()

2000	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (1)	Dec (7)
2001	Jan	Feb (1)	Mar	Apr (1)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2002	Jan	Feb	Mar	Apr	May	Jun (1)	Jul	Aug	Sep	Oct	Nov	Dec

kinterbasdb-help Mailing List for KInterbasDB

kinterbasdb-help — Ask here if you need help on Kinterbasdb