VFP9 no SPs, Win XP SP2, Windows Server 2003, VFP Database
All indexes exist for all fields involved in joins
CPDBF() for all tables =1252
set('collate')=machine
This is a view that is used by another view. This view in the coverage profiler
can take 30-40 seconds to run.
SELECT Ordprod.orderid, Ordsize.orderprodid,;
SUM(Ordsize.ordered) AS totordered,;
SUM(Ordsize.allocated) AS totallocated,;
SUM(Ordsize.shipped) AS totshipped, Ordhead.sbo AS specialord;
FROM ;
Ordsize ;
INNER JOIN ordprod ;
ON Ordprod.orderprodid = Ordsize.orderprodid ;
INNER JOIN ordhead ;
ON Ordprod.orderid = Ordhead.orderid;
GROUP BY Ordsize.orderprodid, Ordprod.orderid, Ordhead.sbo
Any ideas on speeding it up?
TIA,
Mike
--------------------------------------------------------------------
This mail sent through WebMail | Courtesy of Execulink
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
