.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