Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Nov 2003 @ 14:33:42 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Executing multiple SQLs in parallel through JDBC
 
From:   Pudhota, Kiran K

Hi,

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:

[1] Statement.execute, getMoreResults, getResultSet - How would one code multiple SQL statements as a single String. (separate using ; ?)

[2] 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.

Thanks.

Best regards,

-Kiran.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023