Is it timing out at the Front end?
If so, does it time out if you run it from query analyser?
What are you using for the front end?
How many records are there in IPCITYLATLONGISP?
If lots. do you have an index on ipFrom and ipTo?
The query seems a little strange but I will say no more until I know a little more about what you are trying to do.
|