On 24 Jun 2009, at 7:43pm, Dhruv Adhia wrote: > I want to enter 2000 news items at once for the testing purpose. I > would > like to know the shorter way out.
Just make sure you put BEGIN ... COMMIT around the whole block of your INSERT commands. This will greatly speed up the process. On the other hand, if you're not testing the INSERT process, you can put all the INSERT commands into a file and use the 'sqlite3' command line tool to read and execute the commands. So all you'd need to do would be to issue one command. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users