On Thu, Feb 24, 2011 at 4:52 AM, Maddy <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
