We use the batch functionality frequently. How is iBATIS determining what is homogeneous and what is heterogeneous? We have a mix of both straight SQL updates and prepared statement updates.
From: [EMAIL PROTECTED] To: [email protected] Subject: RE: iBATIS and Batch Date: Fri, 29 Feb 2008 08:58:43 -0700 Unfortunately no... that’s possibly something we can consider for future versions. The challenge is that some people have the exact opposite problem. They need the statements to maintain the order of execution. When initially deciding who to help, I decided that preserving the order of execution was more important than performance. I also assumed that if you’re using a mixed order of heterogeneous statements, you could probably find a way to order them by type and send them through to make the most of batching. Whereas the opposite wouldn’t be true, as if I always just reordered the statements for the sake of performance – there would be no way back. I suppose we could support it as an option, but before that I have to ask: Can you reorder your statements? If not, why not? Clinton From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: February-29-08 8:47 AM To: [email protected] Subject: iBATIS and Batch Recently we have been implementing batched SQL calls using iBatis through JDBC. IT appears that iBatis will reorganize batch statements into homogenous calls and treat them as separate batches.... The problem is that is if you do not serially add the homogenous statements, each 'change' from homogeneity results in a separate batch... Does this sound correct? Is there something we can do to control the batching of heterogeneous calls? Thank you, Christopher _________________________________________________________________ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008
