Re: [sqlite] Inserting Values in Bulk

2006-10-05 Thread Jay Calaus
but it is still much slower than what I was hoping. Well, I'm kind of comparing it from my experience with the C program so that is not really a fair comparison. :) Thanks again. Jay --- Dennis Cote <[EMAIL PROTECTED]> wrote: > Jay Calaus wrote: > > > > Now I'm inve

Re: [sqlite] Inserting Values in Bulk

2006-10-05 Thread Jay Calaus
Dennis, > # insert the repeated pr fields into the associated pr table > for n in range(28): > cur.execute("insert into pr values(?, ?, ?)", (id, n+1, float(fields[n+3])) > Even if you don't normalize your table this sample > should show how to use parameters (the question marks > in the SQ