Description:
ActiveSpaces clients(remote, peer members) will retrieve all matched tuples (all the fields) from seeders for Get / Query activity. Is there any work around to get only selective fields from a space?

Example: select key1, key2  from myspace where keys < 1000

Workaround:  From Java API:

Refer to the JDBC example provided in the AS example folder. Using this you can get only the required tuples from a space, such as (select filed1 ,filed2 from space). The JDBC example internal query result will fetch all of the tuples from the cluster and return only the required fields to the JDBC result-set on the client side.

Example:  select key from myspace where key < 1000

The client(remote, peer members) will still retrieve all data from seeders, but will only return the given set of fields as a result. The JVM heap will only have the necessary fields, reducing JVM memory usage.

Workaround:  From BW AS Plugin :

Refer KB :46276 : "How to use the BW JDBC connection palette with ActiveSpaces JDBC Driver".