> | | | | | +-[1465.20ms / 29%] SQL (select): entity=Transaction,
> qualifier=null, {rows=5611}
> | | | | | | +-[72.50ms / 1%] SQL (evaluate): SELECT t0….(proprietary)
this is saying that 30% of your time is spent reading 6000 results from this
query .. .
1) that's a big result,
2) there are either tons of columns or a slow database connection.
> Maybe just too many single statements that should be batched?
> select * from sometable where id = z;
>>
>>> ...if you see a lot of these, it implies that you're not batching
>>> effectively. you can either manually batch fault those, or you can
>>> turn on automatic batch faulting in wonder.
>
>> I changed 2 WODisplayGroups from having no specified batch count,
>> i.e. infinity? to 40 and 200 respectively. Actual count was 31 and
>> 5611 as seen below, I didn't notice any change in the time.
>
> You won't, that setting only affects display. You need to use
> ERXBatchingDisplayGroup.
I do three different aggregating calculations on those 6000 records, they only
have 19 columns but have nine related tables, into which the calculations get
stored.
I get a null exception (below) occurring if I switch from ERXDisplayGroup to
ERXBatchingDisplayGroup.
The error occurs before the WOComponent constructor.
Is the direction of somehow re-writing the usage of the WODisplayGroup to use
batching, a recommended direction?
In both the main Component on the page and a Sub-Component there are two
WODisplayGroups referencing the same table; and then two more WODisplayGroups
in the Sub-Component.
****** ERXBatchingDisplayGroup exception ******
com.webobjects.foundation.NSForwardException
[java.lang.reflect.InvocationTargetException]
null:java.lang.reflect.InvocationTargetException
The below, from the same page as above, is another 15% but it is only a simple
fetch of the month of the year records, from a EOSharedEditingContext?
| | | | | +-[686.13ms / 14%] SQL (select): entity=Months, qualifier=null,
{rows=13}
| | | | | | +-[679.17ms / 13%] SQL (select): entity=Months, qualifier=null,
{rows=13}
| | | | | | | +-[ 4.36ms / 0%] SQL (evaluate): SELECT t0."MONTH_NUM",
t0."THE_MONTH" FROM "MONTHS" t0
| | | | | | +-[ 4.37ms / 0%] SQL (evaluate): SELECT t0."MONTH_NUM",
t0."THE_MONTH" FROM "MONTHS" t0
I am running this profiling while in a WOLips debug launch. It seems like I
should run from a deployed version?
I still find nothing out of the ordinary in the 3 pages of SQL generated by the
profiler, (other than the speed).
----
Baiss Eric Magnusson
http://www.CascadeWebDesign.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
