LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Parts/Attachments: text/plain (19 lines)
Print Reply
Sender:
LISTSERV site administrators' forum <[log in to unmask]>
Date:
Wed, 30 Mar 2005 17:37:13 -0500
Reply-To:
LISTSERV site administrators' forum <[log in to unmask]>
Subject:
MIME-Version:
1.0
Content-Transfer-Encoding:
7bit
In-Reply-To:
Content-Type:
text/plain; charset="us-ascii"
From:
Eric Thomas <[log in to unmask]>
> 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

ATOM RSS1 RSS2