Then which DB engine is better..... Thanks
On Mon, Aug 24, 2009 at 8:16 PM, mos <mo...@fastmail.fm> wrote: > 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=bharanikumariyer...@gmail.com > > -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/
