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
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.