Java 取数据 循环效率变低
--------------------编程问答-------------------- 好长。建议，
可疑的语句加日志打印执行时间，看看哪里耗时最多 --------------------编程问答--------------------
按照提供的方法测试了一下，发现效率变低主要是因为sql语句执行的时间变长了。
处理的时间并没有变长。能指点一下么？？
添加测试的语句：
pstmt = conn.prepareStatement(sql);
System.out.print("" + new Date());//执行的起始时间
rs = pstmt.executeQuery();
System.out.println(" --- " + new Date());//执行的结束时间
下面是测试的输出：
--------------------编程问答-------------------- 会不会是 db 负载太大了，慢的时候，你去 db server 看看负载情况
=Fri Dec 20 09:07:28 CST 2013 --- Fri Dec 20 09:07:29 CST 2013
=Fri Dec 20 09:07:31 CST 2013 --- Fri Dec 20 09:07:31 CST 2013
=Fri Dec 20 09:07:33 CST 2013 --- Fri Dec 20 09:07:34 CST 2013
=Fri Dec 20 09:07:35 CST 2013 --- Fri Dec 20 09:07:36 CST 2013
=Fri Dec 20 09:07:37 CST 2013 --- Fri Dec 20 09:07:38 CST 2013
=Fri Dec 20 09:07:42 CST 2013 --- Fri Dec 20 09:07:42 CST 2013
=Fri Dec 20 09:07:44 CST 2013 --- Fri Dec 20 09:07:44 CST 2013
=Fri Dec 20 09:07:46 CST 2013 --- Fri Dec 20 09:07:47 CST 2013
=Fri Dec 20 09:07:48 CST 2013 --- Fri Dec 20 09:07:49 CST 2013
=Fri Dec 20 09:07:50 CST 2013 --- Fri Dec 20 09:07:51 CST 2013
=Fri Dec 20 09:07:52 CST 2013 --- Fri Dec 20 09:07:53 CST 2013
=Fri Dec 20 09:07:55 CST 2013 --- Fri Dec 20 09:07:55 CST 2013
=Fri Dec 20 09:07:57 CST 2013 --- Fri Dec 20 09:07:57 CST 2013
=Fri Dec 20 09:07:59 CST 2013 --- Fri Dec 20 09:07:59 CST 2013
=Fri Dec 20 09:08:01 CST 2013 --- Fri Dec 20 09:08:02 CST 2013
=Fri Dec 20 09:08:03 CST 2013 --- Fri Dec 20 09:08:07 CST 2013
=Fri Dec 20 09:08:08 CST 2013 --- Fri Dec 20 09:08:12 CST 2013
=Fri Dec 20 09:08:14 CST 2013 --- Fri Dec 20 09:08:17 CST 2013
=Fri Dec 20 09:08:19 CST 2013 --- Fri Dec 20 09:08:22 CST 2013
=Fri Dec 20 09:08:23 CST 2013 --- Fri Dec 20 09:08:27 CST 2013
=Fri Dec 20 09:08:28 CST 2013 --- Fri Dec 20 09:08:32 CST 2013
=Fri Dec 20 09:08:33 CST 2013 --- Fri Dec 20 09:08:37 CST 2013
=Fri Dec 20 09:08:39 CST 2013 --- Fri Dec 20 09:08:42 CST 2013
=Fri Dec 20 09:08:44 CST 2013 --- Fri Dec 20 09:08:48 CST 2013
=Fri Dec 20 09:08:49 CST 2013 --- Fri Dec 20 09:08:56 CST 2013
=Fri Dec 20 09:08:58 CST 2013 --- Fri Dec 20 09:09:04 CST 2013
=Fri Dec 20 09:09:06 CST 2013 --- Fri Dec 20 09:09:12 CST 2013
=Fri Dec 20 09:09:13 CST 2013 --- Fri Dec 20 09:09:20 CST 2013
=Fri Dec 20 09:09:22 CST 2013 --- Fri Dec 20 09:09:35 CST 2013
=Fri Dec 20 09:09:36 CST 2013 --- Fri Dec 20 09:09:49 CST 2013
=Fri Dec 20 09:09:50 CST 2013 --- Fri Dec 20 09:10:03 CST 2013
=Fri Dec 20 09:10:05 CST 2013 --- Fri Dec 20 09:10:17 CST 2013
=Fri Dec 20 09:10:19 CST 2013 --- Fri Dec 20 09:10:32 CST 2013
=Fri Dec 20 09:10:33 CST 2013 --- Fri Dec 20 09:10:46 CST 2013
=Fri Dec 20 09:10:48 CST 2013 --- Fri Dec 20 09:11:01 CST 2013
=Fri Dec 20 09:11:02 CST 2013 --- Fri Dec 20 09:11:15 CST 2013
=Fri Dec 20 09:11:18 CST 2013 --- Fri Dec 20 09:11:31 CST 2013
=Fri Dec 20 09:11:33 CST 2013 --- Fri Dec 20 09:11:46 CST 2013
=Fri Dec 20 09:11:47 CST 2013 --- Fri Dec 20 09:12:00 CST 2013
=Fri Dec 20 09:12:02 CST 2013 --- Fri Dec 20 09:12:16 CST 2013
=Fri Dec 20 09:12:18 CST 2013 --- Fri Dec 20 09:12:31 CST 2013
=Fri Dec 20 09:12:33 CST 2013 --- Fri Dec 20 09:12:47 CST 2013
=Fri Dec 20 09:12:49 CST 2013 --- Fri Dec 20 09:13:02 CST 2013
=Fri Dec 20 09:13:03 CST 2013 --- Fri Dec 20 09:13:17 CST 2013
=Fri Dec 20 09:13:19 CST 2013 --- Fri Dec 20 09:13:33 CST 2013
=Fri Dec 20 09:13:35 CST 2013 --- Fri Dec 20 09:13:48 CST 2013
=Fri Dec 20 09:13:50 CST 2013 --- Fri Dec 20 09:14:04 CST 2013
=Fri Dec 20 09:14:06 CST 2013 --- Fri Dec 20 09:14:20 CST 2013
=Fri Dec 20 09:14:22 CST 2013 --- Fri Dec 20 09:14:35 CST 2013
=Fri Dec 20 09:14:37 CST 2013 --- Fri Dec 20 09:14:51 CST 2013
=Fri Dec 20 09:14:53 CST 2013 --- Fri Dec 20 09:15:06 CST 2013
=Fri Dec 20 09:15:08 CST 2013 --- Fri Dec 20 09:15:22 CST 2013
补充：Java , Web 开发
