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