Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle or SQL server or anything else?
Message
From
25/06/1997 21:44:38
 
 
To
25/06/1997 10:26:47
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00037445
Message ID:
00037759
Views:
43
> >> 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
Previous
Reply
Map
View

Click here to load this message in the networking platform