[JBoss-dev] Caching - Locking - Server Dies!

[K.V. Vinay Menon]

Hello Folks,     Continuing with my load test I find something strange. I have a test harness that simulates 100 clients hitting the server at 100ms. They all retrieve the same data  - 150 odd records  - from the database. The cache size has been set to 100000. Commit option is A. Am not doing any write operations.   1. The retrieve for the first client is high as expected. 2. This then falls rapidly to about 90ms. 3. However the response time then rises to aout 20 seconds.   On checking the server log, I am getting loads of 'LOCKING-WAITING (TRANSACTION)' messages.  And its due to this locking I presume that the response time takes a beating.     a) Why is it not just reading data from cache? b) Why is it locking for read only opertions?   Why is this so? All this seems very strange. Either I am missing something or the caching is not working for high loads.   Regards,   Vinay