Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to QUICKLY determine if table does not have any reco
Message
De
21/07/2009 10:04:53
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
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:
01413544
Vues:
83
>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!

If you don't care on deleted or not then reccount(). It doesn't have any performance hit on large tables, because it doesn't count, it reads the information from table's header (bytes offsett 4-7 keep how many records in file aka reccount).
Other techniques could be checking if file size is bigger than 32*(fcount()+1)+264.

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform