Whats the best way to cut down on MySQL CPU loads, from a coders standpoint?

Close the connection often? Select only the fields you need and not *?

any help welcome.

Thanks