In article <[log in to unmask]>, Donna Garverick
<[log in to unmask]> writes
>
<SNIP>
>without going into long long story about why i don't have any
>performance measurement tools (like glance) available - i'm just going
>to say i don't.  but where do i go from here?  is there such a thing
>as a 'formula' that can be used to calculate how memory a machine
>should have?  proposing to spend 10's of thousands of dollars on a
>'hunch' is not a good thing (is that tm'ed? :-).          - donna

Donna,

Have a look for [log in to unmask], you should find that there's a time limited
evaluation copy of Glance on your system.

However 5 to 6 minutes for a database update is a _very_ long time. Are
you _sure_ there isn't a problem with your database? Another possibility
is that something, maybe the ODBC background jobs, is doing something
like a serial read with the dataset locked thus locking out other users
for some time.

HTH. Best of luck!
--
Mark Undrill                            Telephone: +44 (0)1684 291710
Affirm Limited                          Fax.:      +44 (0)1684 291712
The Great Barn, Mill Street             e-mail:    [log in to unmask]
TEWKESBURY
GL20  5SB       U.K.