On 8/11/08, Kodok Márton <[EMAIL PROTECTED]> wrote: > Hi, > > Does SQLite accepts multiple insert? > insert into table (col1,col2) values (val1,val2), (val3,val4), (val5,val6) > > If not, how can I speed up large inserts? > eg: 1000 rows
one word... transactions > > Regards, > Marton > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
