On 14 Jun 2013, at 4:55am, Vijay Khurdiya <[email protected]> wrote:
> I am quite new with SQLite3, tried sample application to create, read & write > database using SQLite3. > > Now I am trying to write test where multiple process are trying to access > database using SQLite3. To get best result w.r.t Speed & Concurrency what is > best mode & mechanism to be used. Each of the modes and mechanisms supplied by SQLite are best under some combination of database sizes, frequencies of reads and writes, and types of hardware. If any mode or mechanism was better than the others in all cases, SQLite would offer only that one. Do not concern yourself with 'best speed'. Instead write your software in the simplest, fastest and most elegant way possible, then test it out. If it performs acceptably ship it. If not, /then/ you can start investigating ways to improve things and you will have data ready for testing. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
