Author |
Message |
Merri Board Member

Joined: 02 Feb 2009
         Posts: 63 Location: Kanta-Häme

|
Posted: Tue Nov 03, 2009 10: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 7: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 4: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 |
|
 |
|