[ https://issues.apache.org/jira/browse/OFBIZ-4285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Philippe Mouawad updated OFBIZ-4285: ------------------------------------ Attachment: patch-OFBIZ-4285-2.patch Patch that fixes issue on SELECT queries. I am less sur of this one, your critics are welcome. 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 > 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 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira