Hi, It looks like you are using a query that contains a condition of the form "column IN (...)". This query seems to be slow. I guess you need to analyze your application and check if the right indexes exist. Obviously, I can't say what is slow and why because I don't have your application. See also http://h2database.com/html/performance.html#application_profiling - I guess some of the queries use table scans which are slow (in any database).
By the way, this also seems to use a lot of time: 259/18814 at javax.xml.namespace.QName.equals(QName.java:329) at org.apache.xmlbeans.impl.store.Saver.processElement(Saver.java:421) at org.apache.xmlbeans.impl.store.Saver.process(Saver.java:307) at org.apache.xmlbeans.impl.store.Saver$TextSaver.saveToString(Saver.java:1727) at org.apache.xmlbeans.impl.store.Cursor._xmlText(Cursor.java:546) at org.apache.xmlbeans.impl.store.Cursor.xmlText(Cursor.java:2436) at org.apache.xmlbeans.impl.values.XmlObjectBase.xmlText(XmlObjectBase.java:1455) at com.transerainc.rtmc.xml.XmlSimulator.postXml(XmlSimulator.java:63) at com.transerainc.rtmc.xml.SimulatorTask.run(SimulatorTask.java:29) 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.
