File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "search" Watch "search" New topic


akshaj nampelly

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.

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="" target="_blank" rel="nofollow"></a>
jQuery in Action, 2nd edition
subject: search
Similar Threads
NX:Contractor Search Requirement
How to "View Recent Posts" with filters or more than 50?
can anybody tell about map in java
how to call one textfield to another textfield
Mobile contacts Reading and Storing