What kind of dataset are you querying?

Often, much of th work is done on first call of .hasNext and .execSelect is just setup. You can do:

ResultSet results = qexec.execSelect();
qexec.hasNext() ;

as hasNext() is (as is correct for iterators) idempotent between calls of .next.


Results aren't a StmtIterator,

        Andy


On 18/03/11 19:19, Khandeshi, Ami D wrote:
Hi all,



I noticed that iterating thru stmtiterator (thru hasNext) seems take
long time.  Can you suggest better/more efficient way to get information
in a stattments?



Here is a code base where execution query is fast, iterating thru result
is time consuming.



Thanks,



Ami

                         ResultSet results = qexec.execSelect();

                         System.out.println("got result");

                   List<Entity>  entities = new ArrayList();

                   long time=System.currentTimeMillis();

                   System.out.println("Start Iteator");

                         for ( ; results.hasNext() ; )  {



                         System.out.println("In
iterator"+(time-System.currentTimeMillis()));


Reply via email to