
mysql.livejournal.com
MySQL Community's JournalLiveJournal for MySQL Community. Website (www.mysql.org). You're looking at the latest 20 entries. Missed some entries? Then simply jump back 20 entries. Friday, October 15th, 2010. Efficient full-text searchs on large sets of data. I'm doing this using. SELECT * FROM `tb archive` WHERE `text` LIKE '%john smith%' ORDER BY `date` DESC. The problem is that it is too slow. Most searches take 30-60 seconds. If multiple searches are done the server response begins to slow to a crawl for other users. Displayin...
http://mysql.livejournal.com/