On Thu, Feb 24, 2011 at 4:52 AM, Maddy <im4frie...@gmail.com> wrote: > Hi, > I have 4 "SELECT" queries which are accessing same table. > When I executed these queries concurrently using pthreads in Linux, it took > approximate 10 Seconds. > But same 4 queries executed sequentially it only took 2 seconds. > Total Rows in table are 100000. > Sample query is "SELECT column1, sum(column2) from TABLE_NAME;" > > What can be the reason behind this? >
Have you tried this using SQLite version 3.7.5 or are you using a prior version of SQLite? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
