-
1. Re: read-ahead->on-find->page-size performance issues
dsundstrom Jul 15, 2002 3:54 PM (in response to anjarivo)This is covered in the JBossCMP documentation available from FlashLine ($10).
-
2. Re: read-ahead->on-find->page-size performance issues
anjarivo Jul 16, 2002 5:28 AM (in response to anjarivo)I've bought the "full-package" at 60$ for 6months.
On your manual "JBossCMP" page 48 we can read:
"...the page size is set to four, JBoss will execute..
SELECT ... WHERE (id=0) OR (id=1) OR (id=2) OR (id=3)
AND
SELECT ... WHERE (id=4) OR (id=5) OR (id=6) OR (id=7)"
What I understand is "page-size" allow JBoss to retreive
a chunk of Data in one operation. But according to my
experience It seems that the smallest is "page-size" the
better it is to retreive data ??? In ideal world, it SHOULD be the opposite ;-) (less network traffic, less "SELECT" instruction on server side, produce better
performance ! ) -
3. Re: read-ahead->on-find->page-size performance issues
anjarivo Jul 16, 2002 5:28 AM (in response to anjarivo)I've bought the "full-package" at 60$ for 6months.
On your manual "JBossCMP" page 48 we can read:
"...the page size is set to four, JBoss will execute..
SELECT ... WHERE (id=0) OR (id=1) OR (id=2) OR (id=3)
AND
SELECT ... WHERE (id=4) OR (id=5) OR (id=6) OR (id=7)"
What I understand is "page-size" allow JBoss to retreive
a chunk of Data in one operation. But according to my
experience It seems that the smallest is "page-size" the
better it is to retreive data ??? In ideal world, it SHOULD be the opposite ;-) (less network traffic, less "SELECT" instruction on server side, produce better
performance ! ) -
4. Re: read-ahead->on-find->page-size performance issues
anjarivo Jul 16, 2002 5:31 AM (in response to anjarivo)I've bought the "full-package" at 60$ for 6months.
On your manual "JBossCMP" page 48 we can read:
"...the page size is set to four, JBoss will execute..
SELECT ... WHERE (id=0) OR (id=1) OR (id=2) OR (id=3)
AND
SELECT ... WHERE (id=4) OR (id=5) OR (id=6) OR (id=7)"
What I understand is "page-size" allow JBoss to retreive
a chunk of Data in one operation. But according to my
experience It seems that the smallest is "page-size" the
better it is to retreive data ??? In ideal world, it SHOULD be the opposite ;-) (less network traffic, less "SELECT" instruction on server side, produce better
performance ! ) -
5. Re: read-ahead->on-find->page-size performance issues
dsundstrom Jul 16, 2002 3:21 PM (in response to anjarivo)I find this hard to believe, but I guess that is the way your database works. Simply compare the size of the query with the amount of raw data required for the response.
Since there is no other way to block load data you will have to either load all of you data on-find or not use optimized loading. Do you have a better solution?