[
https://issues.apache.org/jira/browse/OFBIZ-4285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philippe Mouawad updated OFBIZ-4285:
------------------------------------
Description:
Hello,
While profiling SQL requests going to DB I noticed a strange behaviour where
Ofbiz builds SQL Statement partly with ? and partly with inline values which
results in lower Database performances.
Issue existed on updateByCondition and has been fixed but it still exists in
deleteByCondition.
It also exists in find where EntityFunction are used for Select queries
Thank you
Regards
Philippe
http://www.ubik-ingenierie.com
was:
Hello,
While profiling SQL requests going to DB I noticed a strange behaviour where
Ofbiz builds SQL Statement partly with ? and partly with inline values which
results in lower Database performances.
Issue existed on updateByCondition and has been fixed but it still exists in
deleteByCondition.
It also exists in find where EntityFunction are used
I there some reason for this code ?
Is there another way to use delegator that makes it work better ?
Thank you
Regards
Philippe
http://www.ubik-ingenierie.com
> Performance : GenericDao does not always use complete PreparedStatement
> -----------------------------------------------------------------------
>
> Key: OFBIZ-4285
> URL: https://issues.apache.org/jira/browse/OFBIZ-4285
> Project: OFBiz
> Issue Type: Improvement
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Philippe Mouawad
> Labels: PERFORMANCE
> Attachments: patch-OFBIZ-4285-2.patch,
> patch-OFBIZ-4285-genericDAO.patch
>
>
> Hello,
> While profiling SQL requests going to DB I noticed a strange behaviour where
> Ofbiz builds SQL Statement partly with ? and partly with inline values which
> results in lower Database performances.
> Issue existed on updateByCondition and has been fixed but it still exists in
> deleteByCondition.
> It also exists in find where EntityFunction are used for Select queries
> Thank you
> Regards
> Philippe
> http://www.ubik-ingenierie.com
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
