Hi All I am doing a SqlFieldQuery on a single cache of around 60 entries on a single Ignite server locally. The query has two parameters and the cache has a compound index of the two parameter field. It takes from 60 to 80 milliseconds to finish, while it takes only 3 milloseconds for the same query in the H2 web console from the same Ingite session. The query string and the screen shot of the H2 web session are listed below.
Is the 60 -80 ms performance normal in Ignite? If not, what might the problem? Thank you Shaomin select TradeOrder._key from "TradeOrder".TradeOrder where TradeOrder.traderId = 417 and TradeOrder.orderId = 12476420 [cid:[email protected]] _________________________________________________________ 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
