Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to QUICKLY determine if table does not have any reco
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01413534
Message ID:
01413535
Vues:
91
>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!

I believe RECCOUNT() doesn't have any performance hit (the information is read from the DBF Header, AFAIK).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform