View Full Version : table overhead
Roost3r
11-01-2002, 03:12 AM
i read that table overhead happens when you delete or update a lot of information; i do this regularly; are my tables made bad or do i just need to optimize my table frequently
SYP}{ER
11-02-2002, 03:50 PM
Here's what I've done:
function optimize ($what){
mysql_query ("OPTIMIZE TABLE $what");
}
Then after I've done all my delete queries, I run optimize ("tableName");
:)
vBulletin® v3.8.2, Copyright ©2000-2012, Jelsoft Enterprises Ltd.