How to optimize full text searches? <p>I know there are a lot of question already on this subject, but I needed more specific information. So here goes:</p> <ol> <li>Ideally what should be the maximum length of characters upon which a full text search can be performed using minimal resources (CPU, memory)?</li> <li>When should I decide between using the <code>LIKE %$str%</code> and full-text search?</li> <li>Is it important to have both versions <code>LIKE %$str%</code> and full-text search implemented and use the optimal one dynamically?</li> </ol>