A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Joined: May 18, 2005
Jun 13, 2005 13:47:00
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.
Joined: Apr 14, 2005
Jun 13, 2005 17:00:00
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
-/a<br />certified slacker...yes, my last name is 'do' - <a href="http://www.luckycouple.com" target="_blank" rel="nofollow">luckycouple.com</a>
can anybody tell about map in java
NX:Contractor Search Requirement
How to "View Recent Posts" with filters or more than 50?
Mobile contacts Reading and Storing
how to call one textfield to another textfield
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015