Announcement

Collapse
No announcement yet.

searchindex table 170MB, word table 11MB, rest of the board tables 55MB

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • searchindex table 170MB, word table 11MB, rest of the board tables 55MB

    How can I reduce my searchindex table (160MB!!!)?
    I noticed that many words are considered as new words in word table because many users put "..." after a word or between two words.
    How can I separate words from "..." , so only the word is indexed (without "...")?

    Example:
    If a user wright forum and other user wright forum... I have two new words. I only want the word forum indexed twice in searchindex.

    If I put 5000 words in badwords.php is too much for performance?
    Last edited by julius; Mon 18 Jun '01, 9:30am.

  • #2
    For 5000 words, yes, that would take a long time since the badword filter has to go through the post as it is being submitted.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X