Archives of the TeradataForum
Message Posted: Fri, 21 Nov 2003 @ 14:33:42 GMT
We have a requirement to execute multiple SQLs, in parallel, using JDBC. We have about 7 SQLs, and in order to reduce the response time, would like to execute them in a parallel fashion. Is there any way to do this?
The 7 SQLs are simple select statements, each returning 1 to 30 records. Currently this takes over 20 seconds.
We are using Teradata Driver for JDBC, release 02.02.00
We were looking at 2 options:
 Statement.execute, getMoreResults, getResultSet - How would one code multiple SQL statements as a single String. (separate using ; ?)
 Write a stored procedure to return 7 out parameters as cursors - Would this help in reducing the overall time to a great extent? Would appreciate if you could point us to some sample code that shows how to work with cursors in Teradata stored procedures.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|