I am doing a simple test on sqlite where in step one, I just write 10,000 records on a simple database having three fileds. In step 2, after the write is done, I want 100 process reading from the database and doing simple SQLs, no update on the databse just simple select read operations. I am getting horrible performance when I increase the number of processes. Now each process only opens the database connection in read only mode. Still I am guessing some lock is placed on the database and that why even the read operation is slowing down drastically with the increase of the number of processes. Any idea what I need to do to boost performance? For 100 processes doing reads it takes like 10 seconds to do 10000 SQL by each process. If I reduce the number of processes from 1000 to 1 it only finishes in a second -- View this message in context: http://www.nabble.com/SQlite-performance-on-multi-process-env-tp23752056p23752056.html Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
