You could do a number of things to speed it up. - Full text index - Extract the domain name to another column index it - Change mysql defaults - Change engine

You could do a number of things to speed it up. - Full text index - Extract the domain name to another column index it - Change mysql defaults - Change engine types. Maybe go in memory - Create lookup table of domains