FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!

New Frihost Search BETA




I have implemented a new Search for Frihost, based on Sphinx (a full text search engine). Please try it out and give some feedback!

The current search (default phpbb 2) works with a few tables. 2 tables to store all the words in the posts and 1 to store the results of the search. The 2 tables with the words take up more than half of the Frihost database. They are pretty bad for the database, considering they have huge indexes. Also it's getting tough for backups.

The second problem with the current search is that during posting it can take way too long to update the search tables when you post a long post (sometimes even short posts). And then things start to time out and what you get are double posts and people complaining about not getting frih$/points (which is done after the search thing). These problems only happen when everything is slow, but because the search is by far the biggest part of the posting process, it causes this problem

Sphinx search is instead not being done while posting. It simply indexes the whole posts database (only posts that are public) at once when I execute the command (or later on a cron job). This means that the newest posts aren't indexed, depending on how often the database is indexed. I don't think it matters if the search is a few days late. It currently takes 5 to 10 minutes to index the whole posts database and it can be done while the forums are fully operational. So this is rather fast considering it currently sometimes takes half a minute or more for a single post.

This means that the search databases can be removed. All the search stuff done during posting also. I guess this will make posting a lot faster.

For searching there needs to be a background process on the server. If it stops, searching won't work until I fix it. I guess this is acceptable since searching is not really that essential and I guess I can monitor it with a script.

The new search is also able to search for exact phrases, like Google. Other options like to search in certain forums or only for a certain user are not implemented. If really needed/requested, I might implement them.

The posts are searched, but the topics of the posts are returned. (it was already this way) I mean that if in a topic a post talks about A and another post talks about B, it won't turn up in the search for all terms A and B.
The results are currently ordered by the time the topic was posted (so new topics will be on top).

The search words of the query are highlighted in the resulting titles and snippets.

The first 100 results are returned and I didn't implement any pagination. I'm not sure if it is needed (I mean worth the effort).



28 blog comments below

Hi..i have a confusion that whether this search engine is for serching the posts or is it a web crawler.Because i tried it with the keyword "online money" any it didnt show any relevant result.Even the most expected result like adsense were not shown.If it is a web crawler then surely there is a major problem with it.
mr_accounts on Sun Apr 12, 2009 4:18 am
@mr_accounts, it is a search for Frihost and not a web crawler. If you want to find Adsense topics, you'll need to fill in Adsense.
Bondings on Sun Apr 12, 2009 10:42 am
Sounds great Bondings. I'm glad the whole timing out and not getting any points thing will be sorted out now.
SpellcasterDX on Sun Apr 12, 2009 9:26 pm
thats nice ... Very Happy Very Happy
jealous494 on Tue Apr 21, 2009 9:45 am
This is pretty good. Comparing to the database I use on my websites, this gives me an idea on how my databases should be shorter comparing to my current ones with tables everywhere.. Keep up the good work. :]
ArmeniansUnited on Thu Apr 23, 2009 5:53 pm
Thanks Very Happy i've been waiting so long for this!
bri4n5 on Thu Apr 23, 2009 6:47 pm
Sweet, It does the job.
Relentless on Sun Apr 26, 2009 3:05 am
I'm confused as to whether these are searchable websites or blogs.
jennifer36987 on Mon Apr 27, 2009 2:22 pm
I did some simple searches Bondings, and it worked well, thanks!
deanhills on Thu Apr 30, 2009 2:37 pm
cool. You guys are better than ohost and co.
foxx36 on Wed May 06, 2009 11:51 am
Thanks. I've been waiting a while for this too.
Lamchops on Tue May 12, 2009 12:54 pm
estoy esperando por esto
ZEUS_REY on Tue May 19, 2009 6:16 am
I've just installed Sphider search, So I'm very keen to have a look at this search.

Worked well..
Possum on Sun May 24, 2009 4:25 pm
realemente no me fifa
dr2g0n on Tue May 26, 2009 10:02 pm
vo a intentar pero si alquien me ayuda con eto se lo agradezco
dr2g0n on Tue May 26, 2009 10:03 pm
this is a good thing
disasters on Thu Jun 04, 2009 6:55 pm
Code:
coooool i wiil try it  my self
sis5253 on Sun Jun 07, 2009 12:34 pm
merhaba
mustafasertdemir on Mon Jun 08, 2009 3:34 pm
haven't played around with it too much yet, but should get better the more we use it.
Burzy on Tue Jun 09, 2009 9:15 pm
@mr_accounts, it is a search for Frihost and not a web crawler. If you want to find Adsense topics, you'll need to fill in Adsense.
blackdog on Thu Jun 11, 2009 7:05 pm
Fantastic! Results 1-27 of about 27 for siamese (0.096 seconds) This seems to be a great place and I am REALLY glad to have found it - it is a REAL community here..........

Bravo FriHost!

Take care and all the best

Sue
graystonscattery on Tue Jun 16, 2009 2:24 am
Congrats FriHost! It works wonders.
Asap170 on Thu Jun 25, 2009 7:42 pm
i wil see think it useful
jesse355 on Tue Jun 30, 2009 8:42 pm
This is pretty good. Comparing to the database I use on my websites, this gives me an idea on how my databases should be shorter comparing to my current ones with tables everywhere.. Keep up the good work. :] think it useful... It works wonders... Very Happy
leodotus on Sun Aug 02, 2009 9:54 pm
Sweet nice Very Happy Very Happy Very Happy Very Happy Very Happy
edywidarto on Sat Aug 22, 2009 3:36 pm
nice search engines!!!
without a search engine i wouldn't have found this wounderful webspace offer!!!
Applause
ichmagtoastbrot on Mon Oct 26, 2009 6:09 pm
Nice work!!!
Lor20 on Sat Feb 27, 2010 6:42 am
This seems to be a great place and I am REALLY glad to have found it - it is a REAL community here
free web hosting
cutecub11 on Tue Mar 02, 2010 5:55 pm



FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.