🚀 go-pugleaf

Hi

hey, thanks! 

Now i use a LIMIT x 1 command in order to get only one row, and later the first() method of the ResultSet. That made things really somewhat faster. 

But the main mistake i made in the prepareRenderer method which i didnt show.

Oliver

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 LIMIT "+rowIndex +" 1 "+ "* FROM Res"+Order;
        if (SetFiltered) sqlCmd = "SELECT LIMIT "+rowIndex +" 1 "+"* FROM Res WHERE "+sqlCmdFiltered+Order;
        ResultSet rs = null;
        try {  rs = stat.executeQuery(sqlCmd);}
        catch (SQLException e) { return null; }
        try {     rs.first();
                  if (columnIndex==0) return SpecialFormat(rs.getObject(1));
                  return NumberFormat(rs.getObject(columnIndex + 1));
        } catch (SQLException e) { return null; }
   }