Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index should be fully optmized
Message
From
04/11/2006 17:02:10
 
 
To
04/11/2006 15:58:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01167140
Message ID:
01167151
Views:
8
>I have a table with 360000 records. One of the field is Integer with a tag. If I do:
>
>
>COUNT FOR NoInsuranc=0 TO lnCount
>
>
>Isn't this suppose to be fully optimizable?
>
>Because, this is not the case presently. I see the counter starting to count as if this wouldn't be. What could cause this reaction?

- Are you accessing data on a local or a network drive?
- Do you have antivirus active?
- What is SET DELETED, and do you have a tag on DELETED()?
- Are any #DEFINEs active?
- Do you get the same result from a plain Command window?
- Do you get the same result on second and subsequent tests?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform