This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android forum!
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>
I agree. Here's the link:
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?