warmPool (Warm a SAM pool)

One way to reduce the amount of time it takes to retrieve results from the 1010data Insights Platform is to "warm" the SAM pool by logging in IDs ahead of time.

The warmPool function logs in available SAM pool user IDs. Additionally, when warming the pool you can provide queries that are run on the IDs as they are logged in. This can speed the retrieval of results for users.

Example without queries or a log file path and with them:

warmPool(url, owner, password, group)

warmPool(gateway, owner, password, group, queries, logfile)

You can run warmPool without logging in or from a session that is logged in. If you are already logged in, you will not have to input your information (url, owner, group, and password) again.

The used IDs should be released at the end of their activity with the platform. When they are released, they are not warmed automatically.

The example below uses warmPool to warm the SAM pool and BaseQuery to provide a query:

import com.tentendata.javasdk1010v2.*;

public class Warming {

    public static void main(String[] args) {
        String gateway;
        String queryXML;
        String tablePath;
        String username;
        String password;
        String group;
        Session session = null;
        Query query;

        BaseQuery[] queries;

        if (args.length < 3) {
            System.err.println("usage: PrintTable USERNAME PASSWORD GROUP");
            System.exit(1);
        }
        username = args[0];
        password = args[1];
        group = args[2];
        System.err.println("Group login to " +
                             group + ", owner " + username);

        gateway = "https://www2.1010data.com/cgi-bin/gw.k";
        queryXML = "<sel value=\"(us_postal_state_code='WA')\"/>";
        tablePath = "pub.public_data.fhfa.fhfa";

        queries = new BaseQuery[1];
        queries[0] = new BaseQuery(tablePath, queryXML);

        int w=Session.warmPool(gateway, username, password, group, queries,
                               "WarmLog.log");
        System.out.println("Warmed " + w + " uids");
        System.exit(8);

        try {
            session = new Session(gateway, username, password,
                                 LoginType.POSSESS);

            query = new Query(session, tablePath,
                              queryXML);
            query.setWindowSize(1000);
            ResultSet results = query.run();
            // Limit rows to 5000 for testing purposes.
            for (long i = 0; i < Math.min(5000,results.numRows()); i++) {
                Row row = results.row(i);
                Datum[] data = row.asArray();
                for (int j = 0; j < data.length; j++) {
                    if (j > 0) {
                        System.out.print('\t');
                    }
                    System.out.print(data[j].toString());
                }
                System.out.println();
            }
        }
        catch (TentenException exc) {
            System.err.println("1010 Exception occurred: " + exc.toString());
        }
        finally {
            if (session!=null) {
                session.close();
            }
        }
    }
}