on 03-22-2011 8:07 AM
Hello,
we have an issue with the message searching in the transaction se91 using the Where-Used List. After I choose the message type I want to search in Programs, the system is searching for it very long - about 100 seconds.
[Screenshot|http://tinypic.com/r/14ky54i/7]
Could you please give me some hints, how to speed up this search?
We have NW701on MaxDB rel. 7.7.07.014.
Thanks for help in advance.
Got it!
All I had to do was the table buffer reset with /$TAB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here's the result: Increasing the parameter CacheMemorySize didn't help. I changed the value to 1280000. The search in se91 is still very long. I would say the time didn't change at all. However I've gained an access to a similar system, so I'm going to check other database parameters too. Indexes of the table cross (which is accessed during the search) seems to be ok. I'll post the solution here if I find the solution.
Besides that, any other hints where to look?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Could you please give me some hints, how to speed up this search?
>
> We have NW701on MaxDB rel. 7.7.07.014.
Assign more memory to the database (parameter CacheSize) so the table containing the cross reference is kept in memory.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks again for the tips. I'll try to change this parameter and then do some tests. I'll get back to you later.
Just for a note, the search takes about 100 seconds. However on another system, where the parameter for cache size is the same, the search is done in a split second, in fact immediately. The only difference is in database; we use MaxDB and the other system uses Oracle. And also in the number of records in the table CROSS. Our system has about 2 milion records, the other system has about 500 thousand.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.