Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select speed question
Message
From
23/12/2004 15:35:22
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Select speed question
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00971916
Message ID:
00971916
Views:
64
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
Next
Reply
Map
View

Click here to load this message in the networking platform