Site Tools


tech_public:webdev (text)

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
tech_public:webdev [2025/02/27 16:59] – [Flarum migration] jasonwchtech_public:webdev [2025/02/27 17:50] (current) – [Flarum migration] jasonwch
Line 64: Line 64:
 ---- ----
  
-**<fs x-large>Reindex search (for chinese)</fs>**+**<fs x-large>Reindex search (for chinese, <fc #ff0000>MySQL only, performance impact</fc>)</fs>**
  
 <code> <code>
Line 73: Line 73:
  
 <code> <code>
-USE YourFlarumDataBaseName;  // 这里替换为你的 Flarum 数据库的名字+USE YourFlarumDataBaseName;
 ALTER TABLE discussions DROP INDEX title; ALTER TABLE discussions DROP INDEX title;
 CREATE FULLTEXT INDEX title ON `discussions` (`title`) WITH PARSER ngram; CREATE FULLTEXT INDEX title ON `discussions` (`title`) WITH PARSER ngram;
 </code> </code>
  
tech_public/webdev.1740646772.txt.gz · Last modified: by jasonwch (text)

Top ↑