On 8/11/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > On Mon, 11 Aug 2008, P Kishor wrote: > > > > 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 > > > > Can you give an example of how to use transactions to accomplish this > specific case?
my suggestion is for speeding up INSERTs, not for doing the INSERT in one statement (although, discussion of that INSERT syntax has taken place on this mailing list... search the archives). Wrt transactions... nothing special BEGIN TRANSACTION; INSERT...; INSERT...; 1000 times COMMIT; > > Chris > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Christopher F. Martin > School of Medicine > Center for Digestive Diseases & Nutrition > CB# 7555, 4104 Bioinformatics Bldg. > University of North Carolina at Chapel Hill > Chapel Hill, North Carolina 27599-7555 > Phone: 919.966.9340 Fax: 919.966.7592 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > > > > > > > > > > > > > > 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 > > > -- 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
