DB Query Optimization....

Hi,

I am having shopping cart in php-mysql.

I am having running slow admin part coz i have many join in query.

The join is required coz of desgin of DB.

So can ny one help to over come this problem?.

How can i optimize my query so i can speed up my query and it will show me fast result.

Thanks in advance.....

 

I would say if you add a index it should solve the problem. You have to put a index on the key joins as

CREATE INDEX part_of_name ON customer (name(10));

MySql Reference http://dev.mysql.com/doc/refman/5.0/en/create-index.html

 

Proper utilization of indexes will help. Something else that can help is using nested select statements instead of joins whenever possible.