- • Study and Learn Database Optimization
- • Failing that use the following tips...
- • MySQL supports the 'LIMIT' clause which can be used
to lower the returned result set to a specified number
- • Never use LIKE or a FULLTEXT index to do complex
searches. Use keywords and an alternative ranking system
- • The only thing worse than using a LIKE clause, is building
your own LIKE clause in PHP.
