Fetching large resultsets taking longer than expected in JDV
Issue
- Fetching large resultsets takes too long
- very large resultsets
- compare a direct connection of a JDBC client
- JDV is in between the client and the database
- response time is increased dramatically.
- Even when JDV does not split up the query or performs additional actions.
- how can we drastically decrease the time JDV spends in processing the resultset
- how can I make the buffermanager fetch much more records at a time than it currently does?
Environment
- Red Hat JBoss Data Virtualization 6.2.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
