![]() |
How to use optimize_database() ? - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: How to use optimize_database() ? (/showthread.php?tid=80175) |
How to use optimize_database() ? - Davidperez - 09-23-2021 Hi guys, I have a question. What use has the optimize database () function? as this function is used? I was looking for information on the internet but could not find exactly what I need to know. The information in the official document of CodeIgniter is very little Sorry for my poor English! RE: How to use optimize_database() ? - kenjis - 09-23-2021 Do you mean this? https://codeigniter.com/userguide3/database/utilities.html#optimize-a-database If you use MySQL, it runs "OPTIMIZE TABLE" https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html See $_optimize_table property in the DB Utility Class. CodeIgniter/mysqli_utility.php at develop · bcit-ci/CodeIgniter https://github.com/bcit-ci/CodeIgniter/blob/develop/system/database/drivers/mysqli/mysqli_utility.php#L63 RE: How to use optimize_database() ? - ikesela - 09-24-2021 optimize on MyIsam table, analyze for innodb table. i use phpmyadmin, or do it manually, refer mysql official documentation |