>>>>> "BP" == Bryan Pendleton <[EMAIL PROTECTED]> writes:
>> A "Guidelines" section starts on slide 19. Slide 24 lists 100-500
>> updates per second -- but, of course, your actual performance will
>> depend on the complexity of your transactions.
BP> Is there a simple way that I can observe what actual performance
BP> I'm getting? That is, does Derby keep its own monitoring statistics
BP> about the activity that is occuring, and, if so, how do I retrieve
BP> those statistics and view them?
BP> I see that there is SYSCS_GET_RUNTIME_STATISTICS, but that seems
BP> to be mostly about execution of a single query; how do I see
BP> information like:
BP> - transactions per second
BP> - IOs per second (read and write)
BP> - active users
BP> - memory usage
BP> etc.
I agree that this would be very useful.
--
Øystein