Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select speed question
Message
De
23/12/2004 15:35:22
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Select speed question
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
00971916
Message ID:
00971916
Vues:
63
In VFP 9, why would this first select statement run very much slower than the last 2 select statements?

In VFP 8 the first select statement runs very quickly. In VFP9 it is extremely slow.
select Lit_LosFK, Lit_Date ;
   from AI!LOSSITEM ;
   where str(Lit_LosFK, 6) + dtos(Lit_Date) in ;
      (select str(Lit_LosFK, 6) + min(dtos(Lit_Date)) from AI!LOSSITEM group by Lit_LosFK) ;
   group by 1, 2 ;
   into cursor curFIRSTLOSSPAYMENT1 nofilter


select str(Lit_LosFK, 6) + min(dtos(Lit_Date)) as TmpKey ;
   from AI!LOSSITEM ;
   group by Lit_LosFK ;
   INTO CURSOR curTemp nofilter

select Lit_LosFK, Lit_Date ;
   from AI!LOSSITEM ;
   where str(Lit_LosFK, 6) + dtos(Lit_Date) in ;
      (SELECT TmpKey FROM curTemp) ;
   group by 1, 2 ;
   into cursor curFIRSTLOSSPAYMENT2 nofilter
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform