[jboss-user] [Performance Tuning] - CMP 2.X finders

Tuesday, 22 August 2006

Hi,

While watching the log file I have seen that findAll queries are translated into:

select a,b,c from tab where (pk=?) or (pk=?) or (pk=?)......

for every primary key in table.

It seems like a very bad way to select , can this be changed to:

select * from tab

Thanks,

Nim

View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3966616#...

Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...