This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Struts and the fly likes search Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "search" Watch "search" New topic
Author

search

akshaj nampelly
Greenhorn

Joined: May 18, 2005
Posts: 18
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

Joined: Apr 14, 2005
Posts: 354
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


-/a<br />certified slacker...yes, my last name is 'do' - <a href="http://www.luckycouple.com" target="_blank" rel="nofollow">luckycouple.com</a>
 
jQuery in Action, 2nd edition
 
subject: search
 
Similar Threads
can anybody tell about map in java
how to call one textfield to another textfield
Mobile contacts Reading and Storing
NX:Contractor Search Requirement
How to "View Recent Posts" with filters or more than 50?