|
My osqa website is currently hosted on Dreamhost, but I'm having problem with process being killed, and some slowness. I see many users recommending Webfaction shared host for djando projects. So I created an account on Webfaction. I was migrating everything easily to Webfaction, until I tried to load my Mysql dump. It was not possible to create triggers, it is not permited on shared host (but it is on DH). I want to have fulltext search, is there any way to get it working properly? I found something about installing my own mysql server, but this will increase even more my memory usage, right? |
|
what I have done, is create a crone job that insert or updates the forum_mysqlftsindex table which is responsible for the full text search. this crone job runs every 5 minutes running the following command: mysql "dbname" -u"user" -p"password" < ~/updatesearch.sql without the quotes... updatesearch.sql has the following: INSERT INTO forum_mysqlftsindex (id, node_id, body,title,tagnames) SELECT id, id, UPPER(CONCAT_WS('n', forum_node.title, body, forum_node.tagnames)),forum_node.title,forum_node.tagnames FROM forum_node ON DUPLICATE KEY UPDATE forum_mysqlftsindex.body = UPPER(CONCAT_WS('n', forum_node.title, forum_node.body, forum_node.tagnames)), forum_mysqlftsindex.title=forum_node.title, forum_mysqlftsindex.tagnames=forum_node.tagnames; I hope that what you need and not just a silly answer :) |
