Bjorn Asmul writes: > What indexes would you recommend on the LCR table? the ones that are automatically installed: CREATE TABLE lcr ( prefix varchar(16) NOT NULL, from_uri varchar(128) NOT NULL DEFAULT '%', grp_id INT UNSIGNED NOT NULL, priority TINYINT UNSIGNED NOT NULL, KEY Key1 (prefix), KEY Key2 (from_uri), KEY Key3 (grp_id) ) $TABLE_TYPE; -- juha