Re: ignite in-memory sql query performance issue

> *发送时间:* 2016年6月6日 16:10 > *收件人:* user@ignite.apache.org > *主题:* Re: ignite in-memory sql query performance issue > > > > Hi Kevin, > > > > Could you please provide the source code of SelectedClass and estimate > number of entries in the cache? As Vl

re: ignite in-memory sql query performance issue

[mailto:voze...@gridgain.com] 发送时间: 2016年6月6日 16:10 收件人: user@ignite.apache.org 主题: Re: ignite in-memory sql query performance issue Hi Kevin, Could you please provide the source code of SelectedClass and estimate number of entries in the cache? As Vladislav mentioned, most probably this is a matter

re: ignite in-memory sql query performance issue

; } public Date getDate() { return date; } public void setDate(Date date) { this.date = date; } } 发件人: Vladimir Ozerov [mailto:voze...@gridgain.com] 发送时间: 2016年6月6日 16:10 收件人: user@ignite.apache.org 主题: Re: ignite in-memory sql query performance issue Hi Kevin

Re: ignite in-memory sql query performance issue

Hi Kevin, Could you please provide the source code of SelectedClass and estimate number of entries in the cache? As Vladislav mentioned, most probably this is a matter of setting indexes on relevant fields. If you provide the source code, we will be able to give you exact example on how to do

Re: ignite in-memory sql query performance issue

Hello, Do you use indexes in a SQL query? If it does not, that try to create a group index over field1 and fild2. You can find a description here https://apacheignite.readme.io/docs/sql-queries On Mon, Jun 6, 2016 at 5:56 AM, Zhengqingzheng wrote: > Hi there, > >

ignite in-memory sql query performance issue

Hi there, When using sql query to get a list of objects, I find that the performance is really slow. I am wondering, is this normal? I tried to call a sql query as follows: String qryStr = "select * from SelectedClass where field1= ? and field2=?"; SqlQuery qry = new