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.