Re: Slow JOIN to convert IP to Country Code
The same query without JOIN part takes only 0.0013 sec to run! -- Eh? 'same' & 'without'?
Something does not compute...
EXPLAIN says there are 20K rows in stats with that dateline range. Does this confirm it?
SELECT COUNT(*) FROM stats WHERE dateline>=1242604800 AND dateline<1242691200
It is a LEFT JOIN, so there is no filtering by the iplist table. Hence, I would expect at least 20K rows in the output. Yet there are only 716?
Subject
Views
Written By
Posted
5306
May 19, 2009 05:05AM
2393
May 19, 2009 07:11AM
Re: Slow JOIN to convert IP to Country Code
2209
May 19, 2009 11:16PM
2244
May 21, 2009 01:34AM
2188
May 27, 2009 11:58AM
2164
May 27, 2009 08:05PM
2112
May 27, 2009 10:13PM
2310
May 27, 2009 07:04AM
2064
May 27, 2009 09:46AM
2077
May 27, 2009 10:05PM
2160
May 29, 2009 10:55AM
2111
May 29, 2009 03:34PM
2416
May 30, 2009 01:43AM
2278
May 30, 2009 10:47AM
2230
May 31, 2009 11:10PM
2584
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.