Optimize PHP quiries to Mysql Database.

I host my Creloaded Pro 6.2 update 8.1 site on Godaddy on a Shared Hosting account. Not a bad place to host but if you are on the shared hosting plan then you are sharing 150 connections to the mysql database with how ever man people they have crammed into that particular server.

Makes for a lot of dropped Mysql connections.

So I have decided to host the database on my local machine I use a DNS update program so my website always knows where to find the data base.

As I have been reading in several forums such as the Creload and OSCommerce forum the website application in general as a lot of PHP code that calls the whole table just to update one field or one update to a section of the admin section updates the whole table not just the field in the table.

Can we say slow slow slow.

So I am looking for someone who is very qualified and familiar with the Creloaded version I have that can correct the quires to do the update to the field not open the whole table just to update one field.

After this is done I will post another project for database optimization but I believe in the cpanel for godaddy I can optimize the database myself.