...

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");

:)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum