Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fast select becomes slow in form
Message
From
29/10/2003 09:56:07
 
 
To
29/10/2003 03:16:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00843940
Message ID:
00844073
Views:
32
Hi Kenneth,

try to replay the select on init of form:
lnStartTime = SECONDS()*1000

SELECT DISTINCT Person.*;
FROM cavr!person_source INNER JOIN cavr!person ;
ON Person_source.person_id = Person.person_id;
WHERE Person_source.source_id = '00031' INTO CURSOR XXXX

WAIT WINDOW 'done loading all people' +STR(SECONDS()*1000-lnStartTime)

lnStartTime = SECONDS()*1000

SELECT DISTINCT Person.*;
FROM cavr!person_source INNER JOIN cavr!person ;
ON Person_source.person_id = Person.person_id;
WHERE Person_source.source_id = '00031' INTO CURSOR XXXX

WAIT WINDOW 'done loading all people' +STR(SECONDS()*1000-lnStartTime)
The second run need 5 seconds ?

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform