SQLite does not support the "row value constructors" http://troels.arvin.dk/db/rdbms/#insert
INSERT INTO tablename VALUES (0,'foo') , (1,'bar') , (2,'baz'); — which can be seen as a shorthand for INSERT INTO tablename VALUES (0,'foo'); INSERT INTO tablename VALUES (1,'bar'); INSERT INTO tablename VALUES (2,'baz'); This could reduce the amount of parsing when bulk-loading data from a file.... I just did a little test: when I .dump a database with a table name x versus xxxxxxxxxxxxxxxxxxxxxxxxxxxx, the bulk load time increases by 8%. This means about 8% of the parsing is the parsing of the table name. I assume, that's about the time that is needed to parse the string 'INSERT INTO tablename VALUES '... Michael Jay Sprenkle wrote:
A review of how PostgreSQL, DB2, MS SQL, MySQL and Oracle implement the SQL 2003 standard: http://troels.arvin.dk/db/rdbms/ Happy Thanksgiving all :)
