Re: Query optimizing

[<sinisa]

Manik Surtani writes:
 > Hi,
 > 
 > Can anyone tell me which of the 2 following ways
 > to extract data are faster/more efficient?
 > 
 > 1.  Method 1
 > **********
 > 
 > SELECT NAME, CODE FROM PRODUCT LIMIT 0, 25;
 > 
 > ... Start Loop: for each row obtained above,
 > 
 >     SELECT SUM(VALUE) FROM PRIPROD WHERE
 > CODE='code_obtained_above';
 > 
 > ... End Loop
 > 
 > 
 > 2.  Method 2
 > **********
 > 
 > SELECT
 >     PRODUCT.CODE,
 >     PRODUCT.NAME,
 >     SUM(PRIPROD.VALUE)
 > FROM
 >     PRODUCT,
 >     PRIPROD
 > WHERE
 >     PRODUCT.CODE=PRIPROD.CODE
 > GROUP BY
 >     PRODUCT.CODE
 > LIMIT 0, 25;
 > 
 > 
 > 
 > The reason I ask is because both PRODUCT and
 > PRIPROD tables have in excess of 1 million rows,
 > and this query needs to be very efficient.  If
 > there is a still better way to do this (using
 > joins, whatever) pls let me know .....
 > 
 > Thanks in advance,
 > 
 > 
 > --
 > Manik Surtani
 > Chief Technology Officer
 > Espada (Pvt.) Ltd.
 > http://www.espadanet.com
 > ICQ: 853533
 > 
 > * The best in e-commerce solutions *
 > 
 > 

Seconde one. Definitely.

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+