If you're using SQL Maps 2.0, then here's what you want to do (in order of importance):
1) Ensure you've specified a parameterMap or parameterClass attribute on your statement. 2) Use an explicitly defined <resultMap> and DON'T allow remapping of results (new 2.0.9 feature) 3) Use a JavaBean (not a Map or XML etc.) 4) Make sure all of your properties are "simple properties" (no dot.notation, array[] access or mixed bean/map properties). 5) Try enabling bytecode enhancement in your <settings> element. If you can do all of this, there will be NO late binding, it will all occur at the time the SQL Map is built. Cheers, Clinton On Thu, 6 Jan 2005 11:55:08 -0500, David Gagnon <[EMAIL PROTECTED]> wrote: > > > > Hi all, > > > > I have result-maps with more than 50 fields. The big problem is the time > of the first access. It may takes 10 to 15 seconds witch is really long to > get the result of a query. I know the result-map and query get parsed at the > first access. Is there a way to speed up the process? > > > > I searched the mailing list for performance tips but haven't found something > substantial. I'm pretty sure I'm not the first one facing this problem so I > probably not searched at the right place L > > > > Any help will be appreciated > > > > By the way, I'm running 1.X version I haven't migrate to 2.0 yet. > > > > Thanks! > > /David > > ----------------------------- > David Gagnon, M.Sc.A., ing. > [EMAIL PROTECTED] > Accovia inc. > Place-Alexis-Nihon, tour 2, bureau 1400 > 3500, boul. De Maisonneuve Ouest > Montr�al, QC H3Z 3C1 > www.accovia.com > > > >
