On 3/30/2005 5:37 PM, Eric Thomas wrote:
>>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
> 

Our build date is 16 Dec 2002. Presumably, this includes the first three
changes listed above. We have 'TUNE_MANY_LISTS=1' in go.user, and are
exporting that variable. Perhaps we will see some additional performance
improvements when we upgrade from 1.8e to 14.3. That is on our to-do list,
but we have not yet set a date.

--
Paul Russell
Senior Systems Administrator
OIT Messaging Services Team
University of Notre Dame