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>
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: search
It's not a secret anymore!