× Heads up!

Aqua Data Studio / nhilam

IDE for Relational Databases
ivangron reported 2016-01-15T20:15:20Z  · last modified 2017-01-26T16:12:36Z

Teradata -> 13.10 -> SetMaxResults -> jdbc FetchSize should not be limited to MaxResults

Priority Low
Complexity Unknown
Component App - General
Version 16.0

Teradata 13.10 added support for setFetchSize() in there jdbc driver.  When a user sets the MaxResults our code would force the FetchSize to be limited to the MaxResults size.  This is standard for all of the native connections.  The issue is that the MaxResults hint does not get passed to the Teradata database and the jdbc driver has to truncate the results after the full results of a sql query has been retrieved.  So reconfiguring the fetchsize limit to the max results limit affects the retrieval time in an unintended way.

  We should test this for all our native drivers and make sure that if the MaxResults setting has to do the work at the jdbc driver level, we are not reconfiguring the fetchsize limit to MaxResults size.

How to test:

  Create a table with 100,000 records.  Configure FetchSize to standard 5000.  Select * from <created table>.  set maxresults in query analyzer to 1.  execute the query.  If the maxresults hint is not handled at the database level, the data retrieval will have to retrieve 1 record per connection, this will bring the query results time exponentially higher.

1 attachment

Issue #14203

Resolved 2016-01-15T20:16:39Z
No due date
Fixed Build v16.0.12, v17.0.0-ga-28, v18.0.0-dev-35
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017