I had tried on sqlite version 3.7.4. Let me check it on sqlite version 3.7.5.
Thanks, Madhav On Thu, Feb 24, 2011 at 9:19 PM, Richard Hipp <[email protected]> wrote: > > > 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
