1. I'm not a SQL expert but I play one on TV.
2. Can you rewrite the Select without joins? Aren't
the joins the bottleneck?
--- [EMAIL PROTECTED] wrote:
> 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.
>
_______________________________________________
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.
