Re: Slow JOIN to convert IP to Country Code
Hello.
Thanks for suggestion. I've tried it and now it's using index for query. But it takes ~11 seconds to run. Is there any way to optimize it further more?
Subject
Views
Written By
Posted
5301
May 19, 2009 05:05AM
2389
May 19, 2009 07:11AM
2207
May 19, 2009 11:16PM
2240
May 21, 2009 01:34AM
2186
May 27, 2009 11:58AM
2162
May 27, 2009 08:05PM
2109
May 27, 2009 10:13PM
2308
May 27, 2009 07:04AM
2062
May 27, 2009 09:46AM
Re: Slow JOIN to convert IP to Country Code
2074
May 27, 2009 10:05PM
2157
May 29, 2009 10:55AM
2108
May 29, 2009 03:34PM
2414
May 30, 2009 01:43AM
2276
May 30, 2009 10:47AM
2227
May 31, 2009 11:10PM
2581
June 01, 2009 04:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.