Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem in SQL
Message
From
26/09/2005 07:46:55
 
 
To
25/09/2005 23:58:06
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Title:
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01052750
Message ID:
01052982
Views:
13
May be it is not the structure you've mentioned which slows down your app. Try to switch:

SET EVENTTRACKING ON
and
SET COVERAGE TO [FileName [ADDITIVE]]

to ensure where is the slowest place in your code. BTW IIF() should by fastes then CASE - ENDCASE

R.Sehnal
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform