Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement takes 10x longer in app vs. vfp
Message
From
20/07/2006 10:06:32
Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States
 
 
To
19/07/2006 16:19:32
Paul Barnes
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Re: Select statement takes 10x longer in app vs. vfp
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137819
Message ID:
01138036
Views:
11
>i've run SYS(3054,2,"cResult") followed by the query, and then a messagebox with cresult, and it is not optimized at all for rushmore. not sure if maybe i'm doing it wrong here.

Try testing with SYS(3054, 12, "cResult") so you can see how it's optimizing the join.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform