Hi Ivan, Would you mind creating at ticket for this issue? https://issues.apache.org/jira/browse/EMPIREDB
Thanks, Francis On 24 September 2014 16:14, Ivan Nemeth <[email protected]> wrote: > Hi, > > the DBReader can be much faster for resultsets with many columns if the > getFieldIndex(ColumnExpr c) method uses some kind of caching. The following > code is 10 times faster for a resultset with 20000 rows and 70 columns. > > public class MyDBReader extends DBReader { > > private static final long serialVersionUID = 1L; > private Map<ColumnExpr, Integer> fieldIndices = new HashMap<ColumnExpr, > Integer>(); > > @Override > public int getFieldIndex(ColumnExpr column) { > Integer i = fieldIndices.get(column); > if (i == null){ > i = super.getFieldIndex(column); > fieldIndices.put(column, i); > } > return i; > } > > } > > What do you think? > > Regards, > Ivan
