Re: VFP6 vs VFP9 query time on large table

I tried SET TABLEVALIDATE TO 0 with no improvement. However, after more trial and error and more research, I discovered the index named invno was not keyed only on invno, but invno+lineno. I created a new index on invno only, cleverly named invnoonly and boom, the query takes less than a second

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