Re: Batch faulting
Re: Batch faulting
- Subject: Re: Batch faulting
- From: Julius Spencer <email@hidden>
- Date: Mon, 2 Jul 2007 20:52:51 +1200
Hi Peter,
I could be wrong about this, but I believe 100 is the default and you
can set this the Advanced Relationship Inspector or the Advanced
Entity Inspector (in the Entity).
I am pretty much pulling this directly from a book I have here on my
desk (Practical WebObjects) as I've read it but not used it (it rang
a bell). I'm guessing Chuck might have more detail on this if you
don't get any further. ; )
Apparently you need to be aware that your sql db might be able to
handle only so long a command. For this reason you may find that you
can only set it so high.
Hope that helps.
On 2/07/2007, at 8:15 PM, Peter Vandoros wrote:
Hi list,
We are in the "optimize" process with one of our apps and i have a
few questions regarding batch faulting/fetching objects:
Is there any reason why the limit batch size for batch faulting is
100 (well at least this is what we have found)?
Why isn't batch faulting enabled by default if it seemingly should
be used in all cases? i.e. don't we want to always batch fetch
objects instead of fetching them one by one when the fault is fired?
Does anyone see any possible issues with specifying all entities to
be batch fetched with a batch size of 100 (or more if possible)?
We are using WO 5.2.4.
Thanks
--
Peter Vandoros
Software Engineer
Etech Group Pty Ltd
Level 3/21 Victoria St
Melbourne VIC 3000
Australia
Ph: +61 3 9639 9677
Fax: +61 3 9639 9577
----------------------------------
IMPORTANT: This e-mail message and any attachments are confidential
and may be privileged. If received in error, please reply to this
message and destroy all copies and any attachments. You should
check this message and any attachments for viruses or defects. Our
liability is limited to resupplying any affected message or
attachments. For more information about Etech Group, please visit
us at http://www.etechgroup.com.au.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40juliusspencer.co.nz
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden