1 posts tagged with indices.
Displaying 1 through 1 of 1. Subscribe:
Full -text search indexes go!
So I finally got around to researching full-text search indexes for the database server today. I whipped up some indexes (that are updated hourly) and ran some tests: searches using the indexes were 5-10x faster than the old way. So I brought back tag and post search for logged in users on the search page.
Consider this a test for the next few days, as I would like to bring search back in all sorts of ways (searching a user's posts, favorites, etc), and hopefully this doesn't kill the database server like it has in the past.
Consider this a test for the next few days, as I would like to bring search back in all sorts of ways (searching a user's posts, favorites, etc), and hopefully this doesn't kill the database server like it has in the past.
Page:
1