Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wishlist: native VFP views
Message
 
 
To
19/12/1999 03:37:14
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00305642
Message ID:
00305898
Views:
29
Walter,

I really don't use large views. Editable views are parameterized so usually the size in the tens of rows, maybe a couple of hundred at most. Read-only views that are large, for reports etc., don't really compare to xbase dml. By time you set relations, scanned and inserted records to the result you are better off with one or two SQL commands IMHO.

>You've got just to load the VFP-view and doesn't execute the relations and filter setting for those records you don't access, giving you a tremendous performance gain over very large SQL - views.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform