Hi,
We have been using SQLite database for a while using single threaded WCF service for our condition based monitor solution. Since, we are facing issues related to scalability for our next generation products due to single threaded architecture, We have been working on using SQLite concurrency access feature through multiple threads and enabling WCF concurrency feature. We did a small prototype using SQLite using ADO.NET by changing Isolation mode = ReadCommited and executed few queries sequentially and parallel and found huge performance improvement. However, when we executed huge select query found that it degraded performance drastically so it will be great help if someone help me out to figure out right usage pattern for this scenario. Here is the execution timing of my query Database size : 856 MB Query : Select * from mytable where <columnName> in ( around 0.2 million comma separated values) Single query execution time: 1388 MS 10 Sequential queries total execution time : 13380 MS 10 Parallel queries total execution time: 37370 MS _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
