SQLite is supposed to process queries as fast as possible. Run your heavyweight queries in a dedicated thread and use your OS' way of prioritizing threads to lessen the "felt impact" on "interactive" threads (at the cost of increasing elapsed time).
-----Ursprüngliche Nachricht----- Von: dd [mailto:durga.d...@gmail.com] Gesendet: Mittwoch, 20. August 2014 10:40 An: General Discussion of SQLite Database Betreff: [sqlite] How to control cpu usage while transaction in progress Hi all, Executing like query in a transaction. Query works with multiple tables and table has 1 million records on desktop clients. CPU goes high when transaction in progress. Is there any way to control the CPU without adding sleep statements? Is there any alternative solution for like queries? (for ex: delete * from emp where empname like "%a") Thanks, dd _______________________________________________ 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
