|
Re: Long response time for "query backup"
2000-02-04 12:43:39
|
Subject: |
Re: Long response time for "query backup" |
|
From: |
Kelly Lipp <lipp AT STORSOL DOT COM> |
|
Date: |
Fri, 4 Feb 2000 10:43:39 -0700 |
Make sure your buffpoolsize in the dsmserv.opt file is set to 131072 (if you
have more than 128MB of memory in the system.) this will improve your cache
hit rate on the db which might help.
Also, lose the -ina switch. That will definitely cost you time. You're
asking the database to do a rather difficult query. Simplify the query as
much as possible.
Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80919
(719)531-5926
Fax: (719)260-5991
www.storsol.com
lipp AT storsol DOT com
|
|
|
