Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle or SQL server or anything else?
Message
 
À
25/06/1997 10:26:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00037445
Message ID:
00037759
Vues:
41
> >> Well, the answer is...it depends. How much data? And > >> particulalry...indexes, which is what will be transmitted for the > >> searching. And when the desired data is found, how much will be > >> transmitted. Do you want to see a list of all clients? Then the entire > >> client table has to be tranmitted? Are you looking for client #34582? > Then > >> the index is transmitted...followed by the data. Then, when you want to > >> find client #634232, the entire index is again transmitted...again > followed > >> by the data. The choice to go C/S really differs for each circumstance. > > > >Should the entire index be transmitted; or should it only be the index > >nodes to get directly to the correct record? And can't you transmit the > >table in chunks, giving the impression of an immediate response while > >the rest of it is loaded in the background? > > > >/Paul > > No..the entire thing needs to get transmitted....using standard VFP. All > the processing takes place on the local machine. The backend server > (Novell, NT) has no way of knowing which pieces of data are perttinent. This doesn't make sense. The Index nodes of the index do point to another node, but the file location can be calculated by multiplying the node number by 512 bytes. FoxPro could then just ask for a chunk of the file, rather than asking for the whole thing. This comes from the VFP Online Documentation, Technical Reference, File Structures. /Paul
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform