fieldsQueryCursor.getAll() performance is really bad

[mawu]

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? my cache size is about
750000;

my code is like this :
queryStr  = "select id shopid,publictransit,fulladdress,phoneno,votetotal,
dishtags, comment, adpic,preferpicurl, 
dealgroupid,dealgrouptitle,dealgrouptype, newmembercardid,
newmembercardtitle, hasbooksetting,  isqueueable,banquetinfo,
gifurl,recommendlang from dpshop where id in (112166223) AND id > 0 "

FieldsQueryCursor<List&amp;lt;?>> fieldsQueryCursor =
igniteRetrieve.getIgnite().cache("dpshopmaterial").query(new
SqlFieldsQuery(queryStr));
List<List&amp;lt;?>> rowData = fieldsQueryCursor.getAll();  // very slow !!!


my record object as follows:
@SchemaDefinition(name = "dpshopmaterial")
public class DpShop {
    @QuerySqlField(index = true)
    @FieldMapping(name = "entityid")
    private String id;

    @QuerySqlField
    @FieldMapping
    private Integer entitytype;
    .................

it has the index field and sql is still very slow and 
the  fieldsQueryCursor.getAll()  consuming 99% of the time . Is there any
way to tune 
cursor.getAll()  or any alternate way to get data from cursor. ]


best regrds

mawu



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/