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 <[email protected]> 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 <[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
