Thank you very much Val. In terms of the warning up, do I need to warm up every cache, or warning up on one cache will produce 0ms on all caches?
Shaomin -----Original Message----- From: vkulichenko [mailto:[email protected]] Sent: 26 February 2016 18:56 To: [email protected] Subject: Re: SQL query performance Hi Shaomin, Before starting to provide best performance, JVM needs some time to warm up and apply all JIT optimizations. It sounds like you're running the query only once, so this doesn't happen. Do this several times in a loop and you should get 0ms timings. -Val -- View this message in context: https://urldefense.proofpoint.com/v2/url?u=http-3A__apache-2Dignite-2Dusers.70518.x6.nabble.com_SQL-2Dquery-2Dperformance-2Dtp3202p3206.html&d=CwICAg&c=lcVbikor4usg5Rj5OmznbA&r=TO3grc1lvgRzUij7SCtFhBPVz_ocKy44E1ncA3VjNmM&m=sbsYZuOdbtp1azmw-UVDUdd-vYUbC64wZLe5Jn-uHTY&s=Ljrz09tKaYvhE01V9lIzVwhj8NzxUu9rDAeUjq1u2bs&e= Sent from the Apache Ignite Users mailing list archive at Nabble.com. _________________________________________________________ This email, its contents, and any attachments transmitted with it are intended only for the addressee(s) and may be confidential and legally privileged. We do not waive any confidentiality by misdelivery. If you have received this email in error, please notify the sender immediately and delete it. You should not copy it, forward it or otherwise use the contents, attachments or information in any way. Any liability for viruses is excluded to the fullest extent permitted by law. Tudor Capital Europe LLP (TCE) is authorised and regulated by The Financial Conduct Authority (the FCA). TCE is registered as a limited liability partnership in England and Wales No: OC340673 with its registered office at 10 New Burlington Street, London, W1S 3BE, United Kingdom
