Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not optimized
Message
From
15/02/2010 14:06:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Not optimized
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01449210
Message ID:
01449210
Views:
144
The following is very slow, presumably because of my use of IN
Select * From KTrackTagDetail							;
	where (Seqno In (Select Seqno From C_Kits)			;
	or SeqnoFG In (Select Seqno From C_Kits))			;
	and Left (RecordType,2) # 'AP'						;
	into Cursor C_Detail
So, how can I speed this up?

Thanks
Jim Nelson
Newbury Park, CA
Next
Reply
Map
View

Click here to load this message in the networking platform