Java Database Connectivity (JDBC)

Hi,
In my DAO object, i have a huge query (with 25 columns). The execution of the query takes 10-15 sec (for 10,000 rows). However the following code seems like taking lot of time.

rs_download_main is the result set.

while(rs_download_main.next()){
/* i used to have code assigning the data from the result set to other VO objects however 
i removed those to make this code look simple. 
Even this code also takes more than 20 min for 
10,000 rows with 25 columns
*/
          cnt += 1;
         if ((newtime1-newtime)/1000 > 2 )
	logger.debug("UBI1 : " + (newtime1-newtime)/1000 + " seconds :" + cnt);
        newtime = newtime1;
        newtime1 = System.currentTimeMillis();			
} //close of while

Can someone help me in resolving this issue?

Thanks

Message was edited by:
padala4u