Re: Slow JOIN to convert IP to Country Code
Sorry for double posting but it seems there was a confusion.
The new query takes less time to execute ~ 11 second and uses index
Explain shows
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE stat range dateline,ip_interval ip_interval 4 490968 Using where; Using index; Using temporary; Using filesort
1 SIMPLE iplist eq_ref PRIMARY PRIMARY 4 vb38.stat.ip_interval 1
Is there any way to optimize this query further more?
Subject
Views
Written By
Posted
5290
May 19, 2009 05:05AM
2381
May 19, 2009 07:11AM
2203
May 19, 2009 11:16PM
2238
May 21, 2009 01:34AM
Re: Slow JOIN to convert IP to Country Code
2181
May 27, 2009 11:58AM
2160
May 27, 2009 08:05PM
2108
May 27, 2009 10:13PM
2307
May 27, 2009 07:04AM
2061
May 27, 2009 09:46AM
2074
May 27, 2009 10:05PM
2156
May 29, 2009 10:55AM
2104
May 29, 2009 03:34PM
2412
May 30, 2009 01:43AM
2273
May 30, 2009 10:47AM
2215
May 31, 2009 11:10PM
2580
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.