Deane Bell <[log in to unmask]> wrote:
 
>This morning I turned on the PREFETCH attribute to see what positive
>effects we might experience since the sentiment seems to be no negative
>effects.  The issue would seem to need further examination it seems to me.
>Environment: 3000/957 c 384MB memory and ~100 users.  While there have
>been no noticeable negative database effects, the users have noted a
>'jerky' screen painting that seems new as of today.  5-8 screen lines will
>post from the database, a pause, then the balance of 5-8 will post.  I'll
>run this way today and turn off the feature tomorrow for a bit more
>'empirical' testing.  While the overall effect may be positive, the
>'appearance' to the user (due to that mid-screen pause) is that there has
>been a deterioration of response time.
 
Smart!  While everybody else is reaching conclusions based on hearsay,
Deane has actually done an experiment on her database and REPORTED her
results to all of us.  Congratulations, Deane!
 
We need more reports like this, folks...
 
+---------------+
|               |
|            r  |  Alfredo                     [log in to unmask]
|          e    |                           http://www.adager.com
|        g      |  F. Alfredo Rego               Tel 208 726-9100
|      a        |  Manager, Theoretical Group    Fax 208 726-2822
|    d          |  Adager Corporation
|  A            |  Sun Valley, Idaho 83353-3000            U.S.A.
|               |
+---------------+