i need to develop a search query for city portal ..select * from ....takes lot for time is there any good query to get fast retrieval form database???????
plz reply its urgent
coervivekmca
-8
Light Poster
Recommended Answers
Jump to Post1. Check if you have index on the column that is being used in the where clause.
2. Select only the desired column in place of all the columns (*).
All 3 Replies
debasisdas
580
Posting Genius
Featured Poster
1. Check if you have index on the column that is being used in the where clause.
2. Select only the desired column in place of all the columns (*).
coervivekmca
-8
Light Poster
sir i need to create a city portal to search "product" for a particular "location"
user input field is "search for" and "loction" .plz tell me how to manage this project ..help me
1. Check if you have index on the column that is being used in the where clause.
2. Select only the desired column in place of all the columns (*).
mwasif
10
Posting Whiz
For better answer post the query and table structure.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.