Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Walter,
>
>I really don't use large views.
IMO a lot of programmers don't use them because they're slow !
>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.
Check the example in the "Differences between xBase and SQL implementations" thread with the references i gave within another thread.
>>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.
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only