Alex,
Thank you very much for your response. Thanks to you, I could cut down the response
time to less than 3 seconds from almost 20 seconds. That is 85% reduction. Like you
said, I enlisted the operation in a transaction and used read-ahead. But I was
wondering on a couple of things. I am sure
I appreciate your response. I am sorry to bug you on this but I have not quite
understood the logic here. Do you mean to say that by including the method in a
transaction or by not making it read-only, I will have a faster response? Could u
please let me know how read-only or a transaction affec
Hi,
My server code has been deployed on JBoss 3.2.1 running on Win2K. I am using CMP to
load data from the database. When I use the following strategy in my CMP query using
EJB-QL
on-load
5
it takes me around 10 sec to load 2000 rows from the database. But when I increase the
page-size