[thelist] PHP - Simple one

[Anthony Baratta]

At 08:40 PM 10/12/2001, you wrote:
>Never mind.  Stupid user error.  Got it fixed.

OK - Spill. Inquiring minds want to know. ;-)

<tip>
Index your tables!! You can see a huge increase in communication speed 
betwen your App and your DB when you index your tables. Use the columns 
queried against your DB as the targets for indexes.

Rebuild your indexes!! If you have tables that churn a lot of data (e.g. 
new data in &/or deleteing data - you can get fragmented indexes. Don't 
forget to take into account processing time when you rebuild the indexes - 
you don't want to affect your users if you can avoid it.
</tip>
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."