Re: Slow JOIN to convert IP to Country Code

[Harutyun Drnoyan]

Hi. I did some tests and found some information in profiling and slow query log.
The slow query log shows Rows_examined: 1 010 815.
Profiling shows that ~99% of execution time takes the stage "Copying to tmp table". After I've changed my iplist table to use char columns instead of varchars the total time of query dropped to ~7.524 seconds, but still huge amount of that time(7.52258=99.98%) takes the stage of copying to tmp table. So it seems to me the only way to optimize this query is speed up this part, but I do not know how.

If you have any idea it will be really helpful.

Thanks.



Edited 1 time(s). Last edit at 05/30/2009 01:02AM by Harutyun Drnoyan.