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
|
||||
table overheadRoost3r 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