Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

search

 
akshaj nampelly
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a number and name field on search page. When I search with number it is very fast, but when I search with name it is too slow eventhough that name is unique. Is this a general problem or code specific.

\akshaj
 
alan do
Ranch Hand
Posts: 354
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
it's a question for your DBA. your SQL statement may not be optimized; more importantly, the 'name' column may not be indexed. not a struts issue. -/a
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic