RE: Table advice.

2009-08-03 Thread Gavin Towey
of the string, and the results will include all subdomains for the given domain you're looking for. Regards, Gavin Towey -Original Message- From: Alexander Kolesen [mailto:kolese...@mail.by] Sent: Saturday, August 01, 2009 11:10 AM To: mysql@lists.mysql.com Subject: Re: Table advice. Hello. Your

Re: Table advice.

2009-08-01 Thread Alexander Kolesen
Hello. Your query performs a full table scan, because if you match text with '%...' wildcard, MySQL can't using index. Try to use external full-text search engines like Sphinx (http://www.sphinxsearch.com/) or Lucene (http://lucene.apache.org). I have a database that I am (will) be using to