KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a database with 75,000+ rows with 500+ entries added per day. Each row has a title and description. I created an RSS feed which gives you the latest entries for a specific search term (ex. http://site.com/rss.rss?q=Pizza would output an RSS for the search term "Pizza"). I was wondering what would be the best way to write the SQL query for this. Right now I have: SELECT * FROM 'table' WHERE (('title' LIKE %searcherm%) OR ('description' LIKE %searcherm%)) LIMIT 20; But the problem is it takes between 2 to 10 seconds to execute the query. Is there a better way to write the query, do I have to cache the results (and how would I do that?) or would changing something in the database structure speed up the query (indexes?)
Tags (comma-separated)
Save Edits
Cancel