Re: [sqlite] Improve INSERT INTO tablename performance for bulk loads....

2005-11-25 Thread Eric Bohlman
Michael Scharf wrote: Eric Bohlman wrote: Using prepared statements with placeholders would reduce the amount of parsing even further. Well, I think INSERT INTO tablename VALUES (0,'foo') , (1,'bar') , (2,'baz'); is a kind of prepared statement, or it could be implemented as a prepared

Re: [sqlite] Improve INSERT INTO tablename performance for bulk loads....

2005-11-25 Thread Michael Scharf
Eric Bohlman wrote: Using prepared statements with placeholders would reduce the amount of parsing even further. Well, I think INSERT INTO tablename VALUES (0,'foo') , (1,'bar') , (2,'baz'); is a kind of prepared statement, or it could be implemented as a prepared statement. How would a