jQuery in Action, 3rd edition
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="http://www.luckycouple.com" target="_blank" rel="nofollow">luckycouple.com</a>
I agree. Here's the link: http://aspose.com/file-tools
subject: search
It's not a secret anymore!