如何优化JAVA应用程序(用Netbeans编写)和MYSQL数据库(由外部DB提供程序托管)之间的速度?
假设我有以下代码;
private void fillPlayersList()
{
try
{
PlayerListModel.clear();
Connection userConn = SimpleDataSource.getConnection();
Statement userStat = userConn.createStatement();
String userquery = "SELECT * FROM player";
ResultSet userResult = userStat.executeQuery(userquery);
if(userResult.next())
{
PlayerList.setEnabled(true);
userResult.previous();
while (userResult.next()) {
int id = userResult.getInt("player_id");
String username = userResult.getString("username");
String ip = userResult.getString("ip");
PlayerListModel.addElement(new PlayerItem(id, username, ip));
}
}
userConn.close();
PlayerList.setModel(PlayerListModel);
}
catch(SQLException e)
{
System.out.println(e);
}
} 这需要很长时间才能完成!我怎么能优化这样的代码呢?
谢谢!
发布于 2013-07-16 02:07:29
您可以从只获取需要的字段的开始
SELECT player_id, username, ip FROM player也许添加一个where条件也会很好,你真的需要所有的玩家吗?
如果您确实禁用了cursor,并继续执行您正在执行的操作...
Statement userStat = userConn.createStatement();
userStat.setFetchSize(0);
String userquery = "SELECT player_id, username, ip FROM player";
ResultSet userResult = userStat.executeQuery(userquery);https://stackoverflow.com/questions/17660729
复制相似问题