> Maybe it's just a regular performance problem, something common, such > as a missing index, or a query is not using the right index for some > reason. Hi Thomas,
Thanks for the reply. Table scan is required. The table scan query only needs to be run 5 times an hour, but the table scan query locks the table for too long and results the update query (166 per second against the table) times out. Also, there are 8000 select query per hour against the table. Regards, Sheng -- 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.
