Greg Sabino Mullane <greg@endpoint.com> wrote:
> Kevin Grittner:
>
>> Did these transactions write anything? If not, were they
>> declared to be READ ONLY? If they were, in fact, only reading,
>> it would be interesting to see what the performance looks like if
>> the recommendation to use the READ ONLY attribute is followed.
>
> Yes, I'll definitely look into that, but the great majority of
> the things done in this case are read/write.
But it is precisely *because* those were fully cached read-only
transactions that the numbers came out so bad. As Robert pointed
out, in other loads the difference in time per transaction could be
lost in the noise.
Now, I know SSI won't be good fit for all applications, but you
might not want to write it off on performance grounds for an
application where "the great majority of the things done ... are
read/write" based on a test which ran only read-only transactions
without declaring them READ ONLY.
-Kevin
