Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Nov 2002 @ 21:49:23 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Tactical Queries
From:   Sam Sterling

Hi Jim,

The NCR/Teradata performance people should be able to help you size it, but in general, it will depend on the query, it's duration, and the volume of data to be returned. And, of course, it depends on what else is running at the time. Since you mentioned that it's single amp, I'm assuming that it will be primary index select. You should be easily able to handle 30 or more queries per amp per second (sounds like OLTP in my book).

 1) First, we do a single-AMP RETRIEVE step from
    mwdw_prd_qmtbls.sxs_repeat_callers by way of the unique primary
    index "mwdw_prd_qmtbls.sxs_repeat_callers.MTN = '2194033732'" with
    no residual conditions.  The estimated time for this step is 0.03

 -> The row is sent directly back to the user as the result of
    statement 1.  The total estimated time is 0.03 seconds.

And, if you use persistent connections, there's no logon time, so with a boatload of sessions, on your configuration, you should be able to handle all 5000 queries within a second or two - worst case.

Does that help?


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