Re: Batch faulting
Re: Batch faulting
- Subject: Re: Batch faulting
- From: Chuck Hill <email@hidden>
- Date: Mon, 2 Jul 2007 09:18:37 -0700
I have used at least a 1000 at times!
Chuck
On Jul 2, 2007, at 1:52 AM, Julius Spencer wrote:
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:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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