>Hi everyone,
>
>Which of the commands below would execute faster assuming you have a million records and 200,000 of this records corresponds to the CUST_ID to compute the OrderAmount?
>
>1. (PRG)
>

>Local lnTotalOrder, lcCustID
>
>lnTotalOrder = 0
>lcCustID = "0008"
>
>Seek &lcCustID    && Seek "0008"
>Do while Customer.Cust_ID=&lcCustID
>   lnTotalOrder = lnTotalOrder + Customer.OrderAmount
>   Skip
>Enddo
>Return (lnTotalOrder)
>

>
>or
>
>2. (SQL)
>

>Select Customer.Cust_ID, sum(Customer.OrderAmount) As lnTotalOrder;
>from Customer  into cursor temp where Customer.Cust_ID="0008" Group by Customer.Cust_ID
>

They are not equal