Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Jul 2006 @ 16:22:02 GMT


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


Subj:   Re: Using Macros through JDBC
 
From:   Diehl, Robert

Glenn,

We use macros from JDBC for all of our tactical requests.

Here are the reasons to use Macros.

1) Query is automatically cached as long as you are using parameterized queries in JDBC or have no parameters. This is very important for tactical queries. We have seen tremendous decreases in reponse time when we can keep the requests in the cache. For example, .06 down to .01 second response time. Some cases even more drastic.

2) Security around macros is better. Users do not have to have access to objects just to execute the macro

3) Better control over what is run. If they only have access to macros, they cannot create something that is not tuned. Again very important for tactical queries.

4) You can implement small changes to macros without having to make application code changes. Application code changes usually require much more extensive testing than a simple isolated result set change.


Berit Zidow and I are giving a presentation at Partners this year which will detail some of our findings around Tactical query performance tuning along with other architecture decisions. While we don't do everything perfectly, hope that some can learn from our findings.


Thanks,

Bob Diehl
Travelocity.com



     
  <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