Thanks. I have database on single Disk.In that case i see it is better to create separate database file.If i am not wrong i will get better edge over concurrency in this case ?
What do you mean by SQlite3 Query with I/O bound ? On Thu, Feb 13, 2014 at 9:22 AM, Hick Gunter <h...@scigames.at> wrote: > .timer on (in the sqlite shell) > > Unless you are storing the databases on different disks AND your SQLite > queries are IO bound I don't expect any performance gains. > > -----Ursprüngliche Nachricht----- > Von: techi eth [mailto:techi...@gmail.com] > Gesendet: Donnerstag, 13. Februar 2014 10:11 > An: General Discussion of SQLite Database > Betreff: [sqlite] SQlite3 Performnace > > Hi, > > > > Is there any way I can check SQlite3 Database read/write timing for > performance measurement. > > > What are the changes in performance if I have single SQlite3 Database file > (Contain 'N' table) or 'N' Database file each contain single table. > > > > Regards, > > Techi > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -------------------------------------------------------------------------- > Gunter Hick > Software Engineer > Scientific Games International GmbH > Klitschgasse 2 - 4, A - 1130 Vienna, Austria > FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. If > you have received it in error, you are on notice as to its status and > accordingly please notify us immediately by reply e-mail and then delete > this message from your system. Please do not copy it or use it for any > purposes, or disclose its contents to any person as to do so could be a > breach of confidence. Thank you for your cooperation. > _______________________________________________ > 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
