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
on
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 conn
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
3 matches
Mail list logo