Re: [sqlite] Improving Performance of INSERT INTO?

Will Leshner <[EMAIL PROTECTED]> wrote: >Try doing all the INSERTs in a single transaction. I didn't realize sqlite3 had transaction support! I must have missed it in the documentation -- off to re-read it. Thanks. - Do you Yahoo!?

[sqlite] Improving Performance of INSERT INTO?

Hi, I'm working on a program that builds a table with 2 columns and up to 500,000 rows. I'm using INSERT INTO to add each row, and the process takes 2 - 3 hours to finish. Since INSERT INTO is the only way I know of to populate a table, I'm assuming that I'll have to find a way to