I was told by the performance group that ADSM will create a
server thread for each database volume, so in that respect more
database volumes may improve performance. I don't knowl, however,
how big of a benefit you receive for the additional
administration of more database volumes.

 -- Tom

On Fri, 5 Jun 1998, Bill Quintrell wrote:

>Bill Quintrell@PROVIDENT LIFE
>06/05/98 03:20 PM
>Re:
>>>> ...
>>>> I'm told that I  should spread my database over
>>>> multiple physical disks.  Supposedly ADSM will
>>>> perform parallel queries.  I'm willing to restructure
>>>> my database if this will make a significant improvement
>>>> but I can't seem to get confirmation.
>
>
>I wonder if the possible "multiple database" benefit is not from
>parallelism but actually due to the executing query only hitting a portion
>(each physical instance) of the database and therefor having only that
>portion "locked" at any one time?  Thus allowing other activity to continue
>if it does not hit the database portion under siege by the query.  If we
>only knew how it worked (or had a better relationship with ADSM
>development), we could...
>As is, any anomaly we discover and work around could be useless in the next
>release.
>