Mike Yearwood
Toronto, Ontario, Canada
Versions des environnements
>The guy is wrong. One "trick" that VFP does use to get its speed is to try to load the entire index for a table into memory, but that's very different that loading the entire table.
I don't think that's quite right either. It loads some of each index tag's data or .idx file and builds a bitmap with one bit per record, which remains in memory for the purposes of the CONTINUE command.
> Perhaps he said that and you were thinking he meant the table? But if he said it loads the entire table, he's not right.
>
>>I was at the user group meeting last week and one of the guys there (seemed to be very knowledgeable) said the following:
>>
>>When you use SQL Select command and even if your WHERE clause is getting just one record (WHERE MYPK = nPk), VFP downloads the entire table (even if it has 1000,000 records) to the local drive and then selects the desired record from the local drive.
>>
>>Is this true?
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