No announcement yet.

Problems - How do WildCard Searches Work?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems - How do WildCard Searches Work?

    Hi all. I just upgraded to the latest and greatest versions of everything, and the server is slow, particularly on wildcard searches and "title only" searches.

    Now, I just realized that my search index was set to read 2 characters as the minimum index. I just changed this to three. Could this cause slow searching? I would think so.

    Also, it seems that MySQL passes off the data (finishes the query) and then it sits in PhP for a while until it finally finishes and outputs to the screen. Is there a large sort routine performed in PhP when doing wildcard searches? The slowdown here doesn't seem to be MySQL related...


  • #2
    Does vBulletin write MySQL queries to disk? I got this error message:

    Warning: mysql_query(): Unable to save result set in D:\PelicanBBS\cgi-bin\vb\admin\db_mysql.php on line 93

    Seems odd to me?



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