Re: sqlobject performance problems (really)

2005-09-27 Thread qvx
qvx wrote: > "autocommit off" attempt: > > connection_string = 'sqlite:/' + db_filename +'?autoCommit=0' > > "no select" attempt: > > t1 = T1(id=t1id, col1=r.col1, ...) I changed : conn_string = 'sqlite:/' + db_datoteka +'?autoCommit=0' conn = connectionForURI(conn_string) SQL

sqlobject performance problems (really)

2005-09-27 Thread qvx
I'm writing a small project and I decided to try pysqlite. The database consists of one master table with five columns and two detail tables with one and two columns each (not counting foreign key columns). The program scans an input file and inserts data into those three tables. First I used pysq