[log in to unmask] (Gary Clarke) wrote:
>Machine: 922-200, OS: MPE/XL B.40.00
>
>Over the past few weeks we have begun to experience severe 'hangs' on
>one of our production systems.
(Snip)
>The detail set contains 2.9 million records (cap: 3.6 mill). There are
>two search items, the first is to an automatic containing 5.0 million
>records (cap: 5.6 mill), the second is to a manual containing 8,519
>records (cap: 11411).
>
(Snip)
>
>Thank you,
>
>Gary Clarke
>[log in to unmask]
>
Just a stab in the dark, Is the second path sorted? If so, is the sort item
near the front of the record? Has anything changed about the values being put
in the sort item (or any item after it? The second path looks to have long
chains (340 records avg per chain) and sort items might be hampering the
performance. (I wouldn't guess that 10 minutes would be the order of the delay,
though).
--
Brian J. White
[log in to unmask]