X-Git-Url: http://source.jalview.org/gitweb/?a=blobdiff_plain;f=datadb%2Fcompbio%2Fcassandra%2FCassandraNativeConnector.java;fp=datadb%2Fcompbio%2Fcassandra%2FCassandraNativeConnector.java;h=8e76d439ff26929084732126845a4c7d7bcbc995;hb=642acd8e446f4ec6765eded00dabd01649e39830;hp=6e6992dad6a998fa4a16dcd5101198beee8d21bc;hpb=53e189c6ddaf7833fd8d8d7a51606d3e020e2eaf;p=proteocache.git

diff --git a/datadb/compbio/cassandra/CassandraNativeConnector.java b/datadb/compbio/cassandra/CassandraNativeConnector.java
index 6e6992d..8e76d43 100644
--- a/datadb/compbio/cassandra/CassandraNativeConnector.java
+++ b/datadb/compbio/cassandra/CassandraNativeConnector.java
@@ -228,17 +228,16 @@ public class CassandraNativeConnector {
 	 */
 	public Integer ReadDateTable(long queryDate) {
 		final long startTime = System.currentTimeMillis();
-		String com = "SELECT jobtime, JobID FROM ProteinData WHERE jobtime = " + queryDate + ";";
+		String com = "SELECT count(*) FROM ProteinData WHERE jobtime = " + queryDate + ";";
 		System.out.println("Command: " + com);
 		ResultSet results = session.execute(com);
 		final long queryTime = System.currentTimeMillis();
 		System.out.println("Query time is " + (queryTime - startTime) + " msec");
-		if (results.isExhausted())
-			return 0;
-		List<Row> rows = results.all();
+		Row row = results.one();
+		Integer count = (int) row.getLong(0);
 		final long endTime = System.currentTimeMillis();
-		System.out.println("Processing time is " + (endTime - queryTime) + " msec");
-		return rows.size();
+		System.out.println("Processing time is " + (endTime - queryTime) + " msec");		
+		return count;
 	}
 
 	/*