Hi Thomas, Actually first one is ATTR1 not ATTR2, typo error when changing the actual column names.
WHERE ATTR1 = 9 AND ATTR2 IN (....) AND ATTR4 IN (.....) The use cause is for reporting. we have web application and we should present data in graphs and tables. "n" number of concurrent users accessing the application and we should show the real-time data in the reporting format. At the same time real-time engine sends data, so I have to update the data. The queries fetches data by grouping the rows in the table. I used max(), sum() grouping functions in this. I would like to know why the updating the table with 3k rows taking longer time when concurrent read requests are there? Is there any configuration settings I can use to optimize this? Thanks, Suresh On Fri, Feb 25, 2011 at 12:49 AM, Thomas Mueller < [email protected]> wrote: > Hi, > > Are you completely sure this is the query? > > WHERE ATTR2 = 9 AND ATTR2 IN (<a large list that doesn't contain 9>) > > This sounds like it would never return rows? > > No matter if that's correct or not, why do you use such a large list > of IN() values? I could optimize the code for this case, and I will > add it to the roadmap. However, I don't understand the use case. What > does the query actually do? What is this large list of literals? > > Regards, > Thomas > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
