Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Notifications
Clear all
Topic starter
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
Posted : 05 Feb 2025 14H02
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
Posted : 08 Feb 2025 14H35