Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is reccount() misleading
Message
From
05/05/2006 07:28:19
 
 
To
05/05/2006 04:19:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01119230
Message ID:
01119534
Views:
26
>>>Hi
>>>
>>>I remember an issue where reccount() could be misleading after a query is not using nofilter. Anyone else remember that or have an example. Or am I just wrong.
>>>
>>>
>>>Thanks
>>>
>>>Nick Mason
>>
>>You're right, use nofilter.
>>Cetin
>Hi Cetin
>
>I thought one argument against automatically using nofilter is that it can be slower as recorda hev to be physically written everytime. I usually check _TALLY to find how many records have been selected. Do you think that is always accurate.

I'd say that the argument that records **have** to be written every time is generally a crock.
It ultimately depends on the OS RAM available for caching.
A cursor is always exclusive so the OS can cache until RAM becomes a problem regardless of what VFP wants.


>
>Nick Mason
Previous
Reply
Map
View

Click here to load this message in the networking platform