php memory problems with search

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • netwind
    Member
    • Apr 2005
    • 32
    • 3.5.x

    php memory problems with search

    I have a forum with 300mb myslq database.
    When I search some common words like "what", "is" and some others (in russian),
    I will get php error :
    Allowed memory size of 31457280 bytes exhausted (tried to allocate 0 bytes)

    I increase php memory size even to 32mb.
    Same error with creating new threads wich contain common words,
    due searching similar threads.
    All searchindex settings are default.

    How I can configure searchindex for succesfull searching and thread creating?
    or maybe vbulleting search system need redesign ?
    Last edited by netwind; Wed 27 Apr '05, 3:50am.
  • Marco van Herwaarden
    Senior Member
    • Nov 2004
    • 6999
    • 3.8.x

    #2
    Check in ACP->vBulletin Options->Message Searching Options:
    - Search Index Minimum Word Length: Increase if necessary. Not sure but i think that Russian uses double byte characters, so maybe this value should be doubled.
    - Search Index Maximum Word Length: Same goes for this one.
    - Automatic Similar Thread Search: You might choose to turn this off.

    Alternative is to increase your php limits even more.

    PS After changing these values you might need to reindex:
    ACP->Import & Maintenance->Update Counters->Rebuild Search Index
    This is a very server intensive task, you might need to empty your indexes first.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment

    • netwind
      Member
      • Apr 2005
      • 32
      • 3.5.x

      #3
      Ok, but can I configure vb for output error "too more results, please use specific query" ?
      Why search operation eat so much memory?

      There are many short significant words such abbreviations.

      ps
      russians use 8bit-texts )

      Comment

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