I had some trouble a while ago when upgrading the jboss server.
This is my Order(afsta)/LineItem(afpos) example which works very well now:
/**
* @ejb.interface-method
* @ejb.relation
* name="Afsta-Afpos"
* role-name="1-afsta-n-afpos"
I guess, there is no XDoclet tags for lazy-resultset-loading yet as it's a new
feature. But I don't know for sure.
You can returned different entity types from ejbSelect methods but not finders.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843145#3843145
R
Alexey,
Thanks again for taking time out. It makes more sense to me now.
I used the finder and the performance improved relatively. 730 records in 12 seconds.
I have not used Lazy-resultset-loading yet.
However sorry to pester you with couple of yet again follow up questions:
1. Do u know the
ejbLoad will still be called on each instance because it's the spec. And this is not
what causes performance problems.
You could also use read-ahead for CMR. But lazy-resultset-loading is not implemented
for CMR.
In case of a finder, you just query the database and return results. In case of CMR,
Alexey,
Thanks For your responses. I deeply appreciate it.
I need one small clarification or confirmation . The CMP query for generating related
beans seems to be on each individual entity (i see ejbLoad being called for each
entity). In a finder you specify the query to get all the entities and
Reposting XML in the code block
|
|
|
|
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842911#3842911
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3842911
-
In your case it would more efficient to use finder instead of CMR. Check out on-line
docs Optimized Loading chapter. And lazy-resultset-loading on the wiki.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842910#3842910
Reply to the post :
http
Thanks joachim,
how do i turn cmp logging>???
I turned on DEBUG messages in log4j.xml...i see the queries but also a deluge of
message from all the other components
IS there a way to turn CMP Logging alone
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3
Ok.
Turn on CMP logging to see which SQL statements are being executed. Have a look at the
docs about load-group, preloading etc. The configuration changes should be noticeable
in the SQL statements executed.
Joachim
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewt
Joachim,
Yes. All of this happens in a Session Facade api with a tx attribute of required.
Even the finder method to find the orders has a tx attribute of required.
Is this the typical throughput that we can expect ???
I am still puzzled that only 1000 records can be retrieved per minute if you
Is your report generated inside a transaction?
It should be, otherwise there is no caching (actually worse, there probably is
caching, but it is discarded all the time).
Joachim
P.S. Damned, I seem to be sounding like a broken record, telling the same story over
and over...
View the original
11 matches
Mail list logo