[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQL optimization

To: d_ware@xxxxxxxxx
Subject: Re: SQL optimization
From: Sinisa Milivojevic <sinisa@xxxxxxxxx>
Date: Mon, 2 Jul 2001 15:36:33 +0300
Cc: luchini@xxxxxxxxxxxxxx, mysql@xxxxxxxxxxxxxxx
In-reply-to: <5.1.0.14.0.20010702121613.00ac3098@xxxxxxxxxxxxxxxxxxxxxxxxxx>
List-help: <mailto:mysql-help@lists.mysql.com>
List-id: <mysql.mysql.com>
List-post: <mailto:mysql@lists.mysql.com>
List-subscribe: <mailto:mysql-subscribe@lists.mysql.com>
List-unsubscribe: <mailto:mysql-unsubscribe-treed=ultraviolet.org@lists.mysql.com>
Mailing-list: contact mysql-help@xxxxxxxxxxxxxxx; run by ezmlm (http://www.ezmlm.org)
References: <01b401c100bf$d3244e50$af04a8c0@wkrcomp03> <5.1.0.14.0.20010702121613.00ac3098@xxxxxxxxxxxxxxxxxxxxxxxxxx>

Dean Ware writes:
> Excellent!
> 
> By changing the order of the tables being joined I reduced the execution 
> time from 2800ms to 20ms!
> 
> Very useful command.
> 
> Thanks very much!
> 

Keep in mind you can help MySQL a lot by setting STRAIGHT_JOIN, to
make it sure that MySQL honors the table order.

This explained in a manual.> 

-- 
Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@xxxxxxxxx>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread78182@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

References:
- Re: SQL optimization
  - From: Dean Ware

Prev by Date: Re: Re: Re: distinct / limit optimization
Next by Date: Re: Using the Windows GUI tool to connect to a MySQL db on a Linux bo x.
Previous by thread: Re: SQL optimization
Next by thread: Trouble with Grant command
Index(es):
- Date
- Thread

This mailing list archive is a service of Copilot Consulting.