• Post Reply Bookmark Topic Watch Topic
  • New Topic

How i use limit and top keyword in eql while we use sqlserver.  RSS feed

 
Ashutosh kumar singh
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,


I am facing problom. Senerio is when we use findall method of ejb and data around 2 lac then our list has been slow. so is any solution or query without passing parameter then please reply me.

@ If any query using Top keyword and Limit then please reply on same.
Regards,

Ashutosh Kumar Singh
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not sure I see the point of going to the bother of using a database neutral technology like Entity Beans then using database specific logic. EJBQL doesn't have a simmilar concept I'm afraid.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!