Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to QUICKLY determine if table does not have any reco
Message
 
To
21/07/2009 10:46:14
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01413534
Message ID:
01413558
Views:
47
>>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.

Thanks!
Tommy Tillman A+ NetWork+ MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform