Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 29 Jan 2005 @ 22:07:44 GMT

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

Subj:   Re: Maximum Limits of Users in Warehouse
From:   Victor Sokovin

  At my shop (that shall remain nameless) which has about 4000 users and about 50 nodes, we had SEVERE problems with blocks on dbc.accessrights when the number of rows went over a million because of the length of time it took to scan through to see if a user had the rights needed to run his/her SQL. At 750k users you'll probably have a lot more than a million rows in accessrights and I would expect similar issues.  

I wonder why this should be such a bottleneck. Did you investigate why exactly the queries were so slow? Could some additional indexing help here?


  <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