Hi!
I got a problem. getValue method performs extremly slow because of slow
hashCode method realisation.
In our project, we convert every result from jOOQ (ExecuteQueryCursor res =
NgQueryPkg.executeQueryCursor(factory, ...) to our inernal fomat.
NgQueryPkg is generated by jOOQ. In this conversation we retrieve fields
from Result using getValue method:
//converter function
public static QueryResponse fromJooqQueryCursor(Result<Record>
cursorQueryResult,...
{ ....
for (final Record record :
cursorQueryResult.sortAsc(QUERY_RECORD_COMPARATOR)) {
String synonym =
record.getValue(QueryRecordField.SCHEMA_SYNONYM.name(), String.class);
String schemaCode =
record.getValue(QueryRecordField.ENTITY_SCHEMA_CODE.name(), String.class);
//other getValue() invocations
This is what profiler shows me:
<https://lh4.googleusercontent.com/-rHzJ_AVypiY/VJFSqoBw7XI/AAAAAAAAADA/ehmJ0bqnl3E/s1600/%D0%91%D0%B5%D0%B7%D1%8B%D0%BC%D1%8F%D0%BD%D0%BD%D1%8B%D0%B9.jpg>
In AbstractQueryPart in hashCode method there is a comment:
"// This is a working default implementation. It should be overridden by
// concrete subclasses, to improve performance"
Who must override it? Me? Or internaj jOOQ AbstractQueryPart's
implimentation classes?
If so, how could I specify jOOQ to use exact realisation of AbstractQueryPart
when giving me result?
Wish you could help me, because currently our system works very slow!
Thank you!
P.S. We'r using jOOq 2.6.7
P.P.S Sorry if the question is stupid - I'm new in jOOQ)
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
