Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 10:49:45 GMT

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

Subj:   Re: Stored Procedures - Pros & Cons
From:   Victor Sokovin


On Tue, 3 Feb 2004 03:01:58 +0100, Christian Schiefer wrote:

  The thing in this case was performance - so we had to go for a PI-access. We build a table on a daily base ( fair enough for routing ) and then find the customer via the SP ( dialed digits " or less" because of extensions ... ).  

  Its better to go for a couple of PI-access queries instead of one "where .. like %"  

  There have been up to 30.000 requests(calls)/day on a ( 2-node 48xx ) and we are far off of measuering any performance issues because of that application.  

Did you have a chance to compare performance of SP against macros in your setup? If so, what was the main reason to go for SP?

The reason I am asking is that when I was reading your posting I recalled Carrie Ballinger's benchmarking report in

www.teradataforum.com/teradata/20031110_210348.htm .

That thread might still be useful for those of us who evaluate options regarding SP and macros.



  <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