One way to optimize database performance for complex data is to take advantage of the database's stored procedure facilities. I don't know if this is possible with the current Entity Engine from the OFBiz project.

See
http://www.javaworld.com/javaworld/jw-04-2004/jw-0405-bottleneck_p.html