I need help with optimizing the mysql Table, It seems to be spiking the server from what my host tells me.

Can anyone help or point me in the right direction. ?

Ej21