Mike Yearwood
Toronto, Ontario, Canada
>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only