|
|
Archives of the TeradataForum
Message Posted: Sat, 29 Jan 2005 @ 22:07:44 GMT
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?
Victor
| |