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.

Unless there is more to it than just that.

I can give you FTP access.


Kemahiran: Pemprosesan Data, PHP

Lihat lagi: where can i find a pro, update oscommerce 2.2 to 2.3.1, open dns, mysql database server, mysql database application, mysql data access, find php, data host, cpanel mysql database, creloaded optimize mysql, so slow, how to find myself, find myself, cpanel ftp, pro find, php forums, php code program, update mysql, php pro, php mysql database, optimize mysql, Mysql, mysql database , mysql admin, my website is so slow

Tentang Majikan:
( 1 ulasan ) Gardner, United States

ID Projek: #117402