>Hi Gang!
>
>Question....
>
>How to QUICKLY determine if table does not have any records.... period.... deleted or otherwise....
>
>I could use RECCOUNT, but this will have a performance hit eveytime I use it on large tables (I guess) .....
>
>What other techniques do you use?
>
>Thanks!
The only way you can have a performance problem with reccount() is, not with the function itself, but in opening the table - for example, if it starts with thousands of deleted records, and you have SET DELETED ON. Also, some users have reported performance problems (again, when opening tables), with certain antivirus products.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
