Query for read all.

edit

This is just the requirement for the screen/front end. If I am not providing any filter it should get me all the values.

I am using C++ interface. And here is my sample code. Please suggest what changes I have to do here.

MyClass sampleObj; // Query to find all the objects where city is NY.. How to get all the objects and what will be the query ??? std::string queryString = "city like 'NY'"; SqlQuery cacheQuery(&sampleObj, queryString); std::vector<ientry*> responseBatch; try{ responseBatch = spaceProxy->readMultiple(cacheQuery, NULL_TX, 10000, DIRTY_READ); std::cout<<" The output size "<<responsebatch.size()<<std::endl; }="" catch(xapexception="" &e){="" std::cout="" <<="" "error="" -="" read="" failed="" "="" <<="" e.getname()="" <<="" std::endl;="" }<="" p="">

I have another question here. I guess the default output size of the readMultiple() method is 100000 objects. Can we go beyond that ? I mean to say that if my space having more than 100000 object and I want to fetch those how to do that.

Thanks Jitendra

There is no default for the readMultiple max objects to return. It would return everything within the space that matches the query criteria (in case you have Integer.MAX_VALUE as the max_objects parameter). This might cause problems with VERY large data set (load the network , load the client and consume large amount of memory).

Here are the different approaches you might want to try when there is a need to fetch/read large amount of data from the space: 1. Use the GSIterator – this will fetch objects in batches from the space. You can control the batch size. This will be a bit slower than the readMultiple but will not consume large memory at the space side. See: http://www.gigaspaces.com/wiki/displa... . Make sure you use the CURRENT IteratorScope when constructing your GSIterator. 2. Use Task Executors and perform your business logic at the space side (this is supported with Java and .Net for now). This will avoid the need to transfer the whole data over the network to the client side. Within the Task implementation you could send back only the data the client needs in optimal manner (and reduce it) rather than sending back the whole object. This will provide the best performance and flexibility. With C++ you can imitate this by using Request/Response model and run C++ PU. 3. Change the LRMI buffer chunk size. This system property should be placed on the GSC JVM using the EXT_JAVA_OPTIONS variable (and also the client side). You might need to twick it until you will get the desired behavior. The system property is com.gs.lrmi.maxBufferSize. It is in bytes. Its default value is 655360. You might want to start with 100000 as a value.

Shay

Hi Shay,

Thanks a lot for the response. Sorry to say, I could not get the proper answer of my first question. What will be the query string to get all the objects from the space ?

Thanks Jitendra

Just to be clear - Do you need to read all MyClass objects within the space or whatever objects you got within the space? Shay

For my current case I have to read all the MyClass objects.

Thanks
Jitendra