Create index on geoip table

November 14, 2008 – 11:16

For report, created index on geoip table and geoip column in log file

CREATE INDEX log_ip ON prefix_log (ip);
CREATE INDEX geocoded_ip_ip ON geocoded_ip (ip);

First query halted the whole server, now query is done in 8 seconds

Sorry, comments for this entry are closed at this time.

BrnDmp