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

[nshaham]

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#3966616

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