At 05:01 AM 8/22/2009, you wrote:
Hi all
Tell Me few Query Optimization Tips ....
For example.. some people saying that , avoid using more of and condition in
the query....
Huh? You need to carefully plan your table structure and use indexes
sparingly on the columns you are using in the Where clauses. An EXPLAIN in
front of the Select statement will show you which indexes it is using.
This sort of very basic things please tell me ...
Also tell me , in the optimization view ,, which database engine is best....
If you need transactions or RI then you have to use InnoDb. Otherwise
MyISAM is quite fast. Again it depends on the type of queries you are
executing.
Thanks
Bharanikumar
There is no magic wand to getting MySQL to run faster except planning and
knowledge. It will take some effort on your part but it will be fun.
Take a look at High Performance MySQL 2nd Edition. Some of the first
edition is online at
http://books.google.com/books?id=sgMvu2uZXlsC&printsec=frontcover&dq=high+performance+mysql#v=onepage&q=&f=false
You can get the second edition at Amazon. Also you may need to read other
MySQL books like MySQL Cookbook
http://books.google.com/books?id=aC3blgT3D3YC&printsec=frontcover&dq=mysql+cookbook#v=onepage&q=&f=false
The 2nd edition is at Amazon.
or MySQL by Paul DuBois is also quite good. These will get you started on
the right foot.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
