Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - really slow. How can I speed it up-indexing?
Message
From
21/02/2004 06:32:35
 
 
To
21/02/2004 04:40:26
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00876858
Message ID:
00879589
Views:
26
Mike,

VFP optimization have concept of deterministic/ not deterministic functions.
CREATE CURSOR randCursor ( F1 I DEFAULT 2015,F2 C(10) DEFAULT SYS(F1))
FOR K=1 TO 100
  APPEND BLANK
NEXT
INDEX ON F2 		TAG TAGSYS2
INDEX ON SYS(F1)	TAG TAGSYS1

CLEAR

SYS(3054,11)
SELECT * FROM randCursor WHERE F2=SYS(F1)
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform