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 
  • Welcome
  • Guest

Faster forums part four

 
Post new topic   Reply to topic    myfreeforum.org Forum Index -> Forum Blogs
View previous topic :: View next topic  
Author Message
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 members
Add Comment
Show Comments


online/offline
PostPosted: Mon Aug 17, 2009 12:58 pm    Post subject: Faster forums part four  Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 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 Send private message Visit poster's website
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 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 Send private message Visit poster's website
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 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 Send private message Visit poster's website
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 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 Send 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
Create your own free forum | Buy a domain to use with your forum