Message
From
21/09/2006 08:57:42
To
21/09/2006 00:49:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01154761
Message ID:
01155926
Views:
25
>Set deleted is on
>no index on deleted()
>cpdbf() and cpcurrent() are both 1252.
>already indexed on prodcode field.
>What would be the normal query time for 415k records to run :-
>select count(*) from tstokmast.
>I've got 25 seconds.
>Yau
I got 0 seconds. Are you running against local data or network? Do you have antivirus?
>no index on deleted()
>cpdbf() and cpcurrent() are both 1252.
>already indexed on prodcode field.
>What would be the normal query time for 415k records to run :-
>select count(*) from tstokmast.
>I've got 25 seconds.
>Yau
I got 0 seconds. Are you running against local data or network? Do you have antivirus?