Author |
Message |
Merri Board Member
Joined: 02 Feb 2009
Posts: 63 Location: Kanta-Häme
|
Posted: Tue Nov 03, 2009 6:22 pm Post subject: mysql fulltext search |
|
|
phpBB.com original thread
I have applied this change to a forum with 180 000+ messages. Unfortunatenaly I'm unable to see any change in speed after building a fulltext index for POSTS_TEXT_TABLE and I am quite disappointed. It takes ten seconds minimum for a search query, and it took this long even before having the fulltext.
Wonder if anyone may have any clue what might have gone wrong. At the moment I'm trying to see if it has any difference that I had the fulltext fields separated to post_subject and post_text and not as just one index with both of them. _________________ Comboa Twitter |
|
Back to top |
|
|
Dog Cow Board Member
Joined: 18 Nov 2008
Posts: 378
|
|
Back to top |
|
|
Merri Board Member
Joined: 02 Feb 2009
Posts: 63 Location: Kanta-Häme
|
Posted: Wed Nov 04, 2009 3:00 pm Post subject: Re: mysql fulltext search |
|
|
That would then be a problem, the site is on a regular shared server on a host. Although I do get it for free so I can't complain about that (sponsored site). The size of the index is nearly 400 MB so it is rather impossible to have it in memory entirely (when you do account the server is hosting I-don't-know-how-many other sites). _________________ Comboa Twitter |
|
Back to top |
|
|
dondino Board Member
Joined: 09 Dec 2008
Posts: 144
|
Posted: Thu Nov 05, 2009 12:15 pm Post subject: Re: mysql fulltext search |
|
|
Oh my godness! I would love to see this phpbb2 forum with more or less.. 180.000 messages!!
well, 10 seconds I think are quite fair for such big database... |
|
Back to top |
|
|
|