time out expired

[brettokumar]

hi i ma using a query like to select country code using between query cause ip if im using this query i will fetch value sometime but i will display time out expired error some time. to over come this problem what can i to do can share your ideas with me my query is SELECT countryShort FROM IPCITYLATLONGISP WHERE '3678433939' between ipFrom and ipTo

with regards, bretto

[Blue_Boy]

Try to optimize your query.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[Paddy Boyd]

Have you considered putting an index on this column (you need to consider that while it may speed up your query, it might also slow down your inserts).

[Ashfield]

Besides optimizing your query (perhaps by indexing the column) you can increase the query timeout in your code.

Bob Ashfield Consultants Ltd