Check out the SMF Function DB!
Started by amordad_yar, June 30, 2011, 01:06:59 AM
Quote from: amordad_yar on June 30, 2011, 01:06:59 AMEven when first installed, the Greek letters changed to garbage when I would change the site to English so that I could help her configure it. We thought it was no big deal until 2 years later she mentioned to me that searches in the site don't work.
$txt['lang_character_set'] = 'ISO-8859-1';
$txt['lang_character_set'] = 'windows-1253';
Quote from: agridoc on July 01, 2011, 07:16:40 AM7. Go to PhpMyAdmin and check SMF database tables. Field text must have been set to utf8_general_ci collation. Table collation may not have been set, can be done manually with PhpMyAdmin.
QuoteA search index can greatly improve the performance of searches on your forum. Especially when the number of messages on a forum grows bigger, searching without an index can take a long time and increase the pressure on your database. If your forum is bigger than 50.000 messages, you might want to consider creating a search index to assure peak performance of your forum.Note that a search index can take up quite some space. A fulltext index is a built-in index of MySQL. It's relatively compact (approximately the same size as the message table), but a lot of words aren't indexed and it can, in some search queries, turn out to be very slow. The custom index is often bigger (depending on your configuration it can be up to 3 times the size of the messages table) but it's performance is better than fulltext and relatively stable.