On Mar 2, 2009, at 1:12 PM, Rajesh Nair wrote: > Hi all > > When I use INSERT INTO stmt how fast sqlite writes it in to the > database. Is it depends up on the OS. Will the record be written to > the database on returning from the exec of INSERT stmt?
Results should be in the db when the transaction is committed. If you have issued a "BEGIN" command, this means when your "COMMIT" has finished. If you have not issued a BEGIN, then the results should be in the database once the INSERT statement has finished running. > > > I am inserting some records in to DB using some threads and in a > perticular condition the threads will be suspended and when I used > SELECT * FROM statement from another function called from one of the > thread, some of the records were not written in to the database. But > after some times the record was written in the DB. What could be the > problem. > > The threads are using individual sqlite handles. and the function that > reads the record is also using seperate sqlite handle. > > Please help > > Regards > Rajesh Nair > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
