myfreeforum.org Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  Who is OnlineWho is Online   Join! (free) Join! (free)  
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
For an excellent guide to using your myfreeforum forum, you can visit
howtodoit
The howtodoit "readonly" forum provides answers and walkthroughs for all common questions.
  • Welcome
  • Country: US
    US
    Address: 38.107.191.108
  • Server Appeal

Faster forums part four

 
Post new topic   Reply to topic    myfreeforum.org Forum Index -> Forum Blogs
Site Admin
Site Admin
Joined: 22 May 2005
Posts: 25518



View user's profile Send private message

A Blog by - admin (no pm's please)




Virtual Cash: 24240
The next move on phpbb2 forums is to implement forum search using mysql full text search. This would replace the native phpbb2 search system with the one now available in the database system.

This has the benefit of being far far faster both when searching and when a post is posted/edited. When a post is entered to the database every word has to be laboriously processed into an index system, on large forums that process is bound to be slow.

There are downsides to this, namely you will get a slightly different set of search results when searching a forum. Basically all searches on text are subject to somewhat arcane decisions made by the search designers, rules that are needed both for speed and for keeping database sizes to a sane level. phpbb2 has its own ideas on this, mysql has another set of ideas.
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums
Author Message
admin (no pm's please)
Site Admin
Site Admin


Virtual Cash: 24240

Joined: 22 May 2005
Posts: 25518



Add Karma

rated by 214 members
Add Comment
Show Comments

online/offline
PostPosted: Mon Aug 17, 2009 3:05 pm    Post subject: Reply with quote




I was sort of thinking this would be a big chunk of work, but it is written and basically working. Though the code to actually change forums over needs to be done.
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums

Back to top
View user's profile Private message Visit poster's website
admin (no pm's please)
Site Admin
Site Admin


Virtual Cash: 24240

Joined: 22 May 2005
Posts: 25518



Add Karma

rated by 214 members
Add Comment
Show Comments

online/offline
PostPosted: Wed Aug 19, 2009 10:48 am    Post subject: Reply with quote

Code that is virtually identical to what we will use here is now running on the downsizer forums.

If there are no issues I may kick this off tomorrow night. It will randomly gradually convert larger forums. I will make the limit such that this forum is effected so we can see more first hand how well it works.
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums

Back to top
View user's profile Private message Visit poster's website
admin (no pm's please)
Site Admin
Site Admin


Virtual Cash: 24240

Joined: 22 May 2005
Posts: 25518



Add Karma

rated by 214 members
Add Comment
Show Comments

online/offline
PostPosted: Wed Aug 19, 2009 1:58 pm    Post subject: Reply with quote

Posting is unquestionably miles faster
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums

Back to top
View user's profile Private message Visit poster's website
admin (no pm's please)
Site Admin
Site Admin


Virtual Cash: 24240

Joined: 22 May 2005
Posts: 25518



Add Karma

rated by 214 members
Add Comment
Show Comments

online/offline
PostPosted: Wed Aug 19, 2009 3:47 pm    Post subject: Reply with quote

The upgrade is pretty much ready to go, and probably does not conflict with the new Wiki code.

So I may well install tomorrow and see what happens



_________________

Family Friendly Shareware | | Web Design/Services | Free Forums

Back to top
View user's profile Private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    myfreeforum.org Forum Index -> Forum Blogs All times are GMT
Page 1 of 1
 
 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Card File  Gallery  Forum Archive
Powered by phpBB © 2001, 2005 phpBB Group