Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INNER JOIN or Sub-query?
Message
From
20/03/2006 10:48:38
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01105835
Message ID:
01105856
Views:
17
>>join can to be faster but it is formally incorrect.
>>if you use c_temp here once only, doesn't index it, vfp does this in a faster way
>
>Are you sure I don't have to index this c_temp cursor? I added the index today in the morning, it seemed to degrade performance...
>
>Thanks.

put TimeToStr(dtot(m.tdDate+1)-1) out of the query, into a variable,
or directly into the lcFilter string <>

uses
Employee_queue_schedules.tScheduled_time < ] + ;
	<<TimeToStr(dtot(m.tdDate+1))>> + ;
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform