Hi,

It is should not be very slow.
If you will not use index, then SQL will work slow.

You can try to  use QueryEntity[1] without indexs on fields.

How many index do you use?
Could you please provide this classes?

Please properly subscribe to the user list so that we can see your questions
as soon as possible and provide answers on them quicker. All you need to do
is send an email to ì user-subscr...@ignite.apache.orgî and follow simple
instructions in the reply.

[1]:
https://apacheignite.readme.io/docs/sql-queries#configuring-sql-indexes-using-queryentity


junyoung.kang wrote
> Hello
> 
> In my test that I put data(datasize is 500,000,000) into cache. 
> 
> and I use this data connected apache zeppelin . and use data with sql.
> 
> But  cacheconfiguration set setIndexedTypes ( key, value)..... very very
> slow.....
> 
> so I removed setIndexedTypes(in cacheConfiguration).. But I can't use sql. 
> 
> How to resolve this problem??
> 
> In other words, I want to put data high performance when using
> setIndexedTypes or I want to use Sql without setIndexedTypes.





--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Ignite-Cache-setIndexedTypes-Question-tp8895p8903.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Reply via email to