🚀 go-pugleaf

Hi

i have in one special project a HSQL database which in principle 
works fine, but my user complained that it gets slow once it has 
only 100 or more entries. Heres the getValueAt method which might
have a performance problem.

@SuppressWarnings
({"ReturnOfNull", "LoopStatementThatDoesntLoop"})
public Object getValueAt(int rowIndex, int columnIndex) {
        Statement stat = null; 
        try {  stat = MyDBConn.createStatement(); }
        catch (SQLException e) {  return null;  }
        String Order = getOrder(SetAscending);  
        String sqlCmd = "SELECT * FROM Res"+Order;  
        if (SetFiltered) sqlCmd = "SELECT * FROM Res WHERE "+sqlCmdFiltered+Order;
        ResultSet rs = null;
        try {  rs = stat.executeQuery(sqlCmd);}
        catch (SQLException e) { return null; }
        try {  while (rs.next())
               {  rs.absolute(rowIndex + 1);
                  if (columnIndex==0) return SpecialFormat(rs.getObject(1));
                  return NumberFormat(rs.getObject(columnIndex + 1));
               }
        } catch (SQLException e) { return null; }
        return "";
}

regards

Oliver