List:General Discussion« Previous MessageNext Message »
From:bharani kumar Date:August 26 2009 4:48am
Subject:Re: Hi Query Optimization steps
View as plain text  
Then which DB engine is better.....

Thanks

On Mon, Aug 24, 2009 at 8:16 PM, mos <mos99@stripped> 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=1
>
>


-- 
Regards
B.S.Bharanikumar
http://php-mysql-jquery.blogspot.com/

Thread
Hi Query Optimization stepsbharani kumar22 Aug
  • Re: Hi Query Optimization stepsmos24 Aug
    • Re: Hi Query Optimization stepsbharani kumar26 Aug
      • Re: Hi Query Optimization stepsJoerg Bruehe26 Aug
        • RE: Hi Query Optimization stepsJerry Schwartz26 Aug