• Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB Query not executed fast  RSS feed

 
Deepak Kumar pandey
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All

Following Query written in EJB 3.0 Session Bean not executed fast, it takes more than 1 minutes time to execute on more than 40,000,00 record.

Query are:

"SELECT gs FROM GrcSurveyFormFamilyMemberEntity gs WHERE gs.grcSurveyform.familyhead LIKE :familyHeadName and gs.name LIKE :name"



thanks
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!