CodeIgniter Forums
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