Re: VFP6 vs VFP9 query time on large table

I'm just gonna throw out a WAG......  SET TABLEVALIDATE TO 0 in VFP9 and then re-test fresh.

On 1/17/2023 12:52 PM, Jeff Roberts wrote:

I have a large table, about 1.5GB with an index on invno which is a char 6. Files are on a file server, client machine where I am running VFP6 and VFP9 is connected via gigabit ethernet.

I run SELECT * FROM invoicdt WHERE invno = '989426' In VFP6 it takes about 6 seconds. In VFP9 it takes about 60 seconds. Anybody have any idea why it is so much slower in VFP9?