stubarny Posted December 4, 2006 Share Posted December 4, 2006 Hi,Our host has just informed us that we can't change the min word length for our fulltext indexes because we're on a shared hosting plan.I'm considering ploughing on with my site design and having both FULLTEXT and normal INDEX versions of the same columns until we can afford dedicated hosting. But I'm unsure what the magnitude of the slowdown in the meantime may be.The database will contain around 500,000 job adverts so if someone types in 'php' (min word length is 4) roughly how long would it take to do a search using the standard index?If it will take a very long time are there any other solutions that would speed things up?Thanks for your help!Regards,Stu Quote Link to comment Share on other sites More sharing options...
the_oliver Posted December 4, 2006 Share Posted December 4, 2006 In reality mySQL should happily chew through that number of fields at a desent speed regardless of the length used. What will have more of an effect are the specs of the server its running on, and how hard the other uses are hammering the connection. Being on shared hosting you are unlikly to be able to find this out. You could consider simple hosting your database with another provider?You could possibly speed it up by having a table only containing the name (such as 'php') and an id_number in it, relating to the full infomation in the other table? Just meens the table is smaller for the search to plow through. Just a thought. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 6, 2006 Share Posted December 6, 2006 MySQL has very limited text searching capabilities... there are a number of add-ons that work quite well, but you can always write you own index. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.