Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nodataonload
Message
 
 
À
09/04/2001 11:01:51
Randy Hooper
Ranco Business Software
Tampa, Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00493567
Message ID:
00493585
Vues:
12
>? parameterized view the view in DE has been set for nodataonload .t., If the set of records coming from a table that has 50,000 records. My question, Is the set of records I have asked for the only records traveling the network or did all 50,000 records come over and only display the records I ask for.

If the view is optimizable, then the entire index is sent over the network. That is processed to determine which records are to be returned and then only those records are retrieved over the wire.

If the view is not optimizable then the entire table is sent over the wire for processing.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform