>Are you sure? And how does VFP know which part of the file to transfer?
In George Goley's book "Creating FoxPro Applications", he cites the following example:
Sample table: 449,996 records occupying over 40Mb of disk space on a LAN.
He performed the following:
SET EXCLUSIVE OFF
SELECT li_ivno, li_invntry FROM bkitms WHERE ;
li_ivno="199100000001" OR ;
li_ivno="199100100000"
The query completed in 1.5 seconds, returning the first two and the last five records from the bkitms table.
The LAN obviously couldn't transfer 40Mb in that timescale.
He did a similar demo with 5 users simultaneously querying a 680,000 70Mb+ table. Each query completed within 2 seconds, with subsequent queries completing in less than a second.
This was in FoxPro 2.5, although the principle is the same.
I have no idea how FoxPro (any version) does this, but I've demonstrated it with my own data.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement