PHP - Optimize database table … Easy trick

ComputerEducationWorld.com Categories:
Free Computer Books Online, PHP, PHP 5 Power Programming, C Programming, C For Beginners, Professional C sharp, INDEX - C# Professional in 15 days, Java, Java 2 (simpler way-Old version), Javascript Tutorial for Beginners, HTML, HTML for Beginners, HTML For Advanced, CSS, CSS For Beginners, CSS Advanced, Basic of Computers, Javascript, Free Web Designing Courses, Introduction to JavaScript, Javascript For Beginners, Download Free E-book, .Net, News and Alerts, Ajax, PHP Script, PHP and XML, PHP Ad Management, PHP Classes, MYSQL, Mysql Classes, Mysql Functions, Tips and tricks, Mozilla firefox tricks, Notepad tricks, Windows tricks, MS word tricks, miscellaneous tricks, HTML Tips and Tricks, PHP Tricks, PHP & MySQL, PHP and MySQL - From Beginning to Professional, INDEX, Basic of MySQL, INDEX - MySQL Basic, Wordpress, Wordpress Plugins, Webmasters, Linux/Unix, jQuery

PHP - Optimize database table … Easy trick

42 views

How to optimize PHP database table… Here code goes:

dbConnect()
$alltables = mysql_query(”SHOW TABLES”);
while ($table = mysql_fetch_assoc($alltables))
{
foreach ($table as $db => $tablename)
{
mysql_query(”OPTIMIZE TABLE ‘”.$tablename.”‘”)
or die(mysql_error());
}
}

« PHP - make webpage password protected	PHP - Send an alert email »
Posted on Monday, March 9th, 2009 at 10:54 am under PHP Tricks \| RSS 2.0 Feed

Post Comment

You must be logged in to post a comment.