Notifications
Retirer tout
Ask questions
2
Posts
2
Utilisateurs
0
Reactions
818
Vu
Début du sujet
Hello,
I would like to ask a question
To "cleanup" the database, with all changes, additions, etc we make on our projeqtor after a few years, is there a need to reindex the db ? , is it possible ?, if yes, how ? (I'm asking for my manager)
Thank you
Posté : 05/02/2025 2:02 pm
Something like
REPAIR TABLE [TableName]; REINDEX TABLE [TableName]; REINDEX DATABASE [DatabaseName]; OPTIMIZE TABLE [TableName];
This can improve perfomance of you "deleeted" many lines (for instance, moving history to historyarchive)
Note that phpMyAdmin proposes easy REPAIR and OPTIMIZE feature
Posté : 08/02/2025 2:35 pm