Re: Anyone else having server database contention problems?
1998-06-05 15:20:34
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.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: Anyone else having server database contention problems?, (continued)
- Re: Anyone else having server database contention problems?, Carl Makin
- Re: Anyone else having server database contention problems?, Bill Quintrell
- Re: Anyone else having server database contention problems?, Purdon, James
- Re: Anyone else having server database contention problems?, Bill Quintrell
- Re: Anyone else having server database contention problems?, Purdon, James
- Re: Anyone else having server database contention problems?, Bill Quintrell
- Re: Anyone else having server database contention problems?, Kerssen, Larry
- Re: Anyone else having server database contention problems?, Fluker, Tom R
- Re: Anyone else having server database contention problems?, Richard Sims
- Re: Anyone else having server database contention problems? -Reply, Andre Siu Young
- Re: Anyone else having server database contention problems?,
Bill Quintrell <=
- Re: Anyone else having server database contention problems?, buser andreas
- Re: Anyone else having server database contention problems?, Thomas A. La Porte
- Re: Anyone else having server database contention problems?, Sheelagh Treweek
|
|
|