Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 02:01:58 GMT


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


Subj:   Re: Stored Procedures - Pros & Cons
 
From:   Christian Schiefer

Hi,

we implemented a solution for a CTI-Server, which was taking its routing information from the Warehouse.

Incoming parameter was "dialed digits" --> Outgoing Result: Several Customer infos.

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.


Christian



     
  <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