Wed, 30 Mar 2005 17:37:13 -0500
|
> We have approximately 20,000 lists on the server, and the 'query *'
> command was taking approximately 45 minutes to complete. After we licensed
> HPO, we upgraded from 1.8d to 1.8e. Now, the 'query *' command completes
> in 10-30 seconds. The delay is noticeable, but acceptable.
You are more patient than I am ;-) The following 14.3 changes would make a
big difference to you. Some of the earlier ones may be included in the build
you are running (just compare your build date to the date of the change).
18E-0005 02/06/08 [P] Increase default extents for LSWLSTLL
18E-0018 02/08/26 [P] Performance improvement for QUERY * (HPO)
18E-0020 02/09/05 [P] Add TUNE_MANY_LISTS option
18E-0157 04/10/11 [I] Suggest TUNE_MANY_LISTS option when appropriate (HPO)
18E-0158 04/10/13 [P] WA performance improvement with many lists (HPO)
If you have #0020, make sure you also have TUNE_MANY_LISTS=1.
Eric
|
|
|