I checked with following scenario. There are 2 script 1) continuously inserting a row at a time in table with exclusive lock mode.
2) executing 4 SELECT queries. e.g. o SELECT column1, SUM(column2) FROM table_name WHERE column3 BETWEEN X AND Y GROUP BY column1; o SELECT column4, SUM(column2) FROM table_name WHERE column3 BETWEEN X AND Y GROUP BY column4; o SELECT column5, SUM(column2) FROM table_name WHERE column3 BETWEEN X AND Y GROUP BY column5; o SELECT column6, SUM(column2) FROM table_name WHERE column3 BETWEEN X AND Y GROUP BY column6; And I got same result in Sqlite 3.7.5 and 3.7.4. Thanks, Madhav On Fri, Feb 25, 2011 at 7:28 PM, Maddy <im4frie...@gmail.com> wrote: > 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 <d...@sqlite.org> wrote: > >> >> >> 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
