Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Total of records after delete
Message
From
10/12/2009 11:39:13
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01438395
Message ID:
01438420
Views:
37
They are very small records. So 20 thousand records in
a database running in a very powerfull machine that's
not a problem these days.
All operations I've done in the database are returned in
some miliseconds.
But, anyway, I will do some tests to check performance.
Thanks!


>>Thanks Naomi!
>>By now it's just about 20 thousands records. Very few.
>
>::)))
>
>If it's 20 thousands, then indeed use count(*) rather than select 1
>
>
>Though, perhaps, I need to run a quick test myself, even if I'm positive what will get better speed.
***
TONY Nascimento
*****************

"Your mind is like a parachute. It only works if it is open" - Anthony J. D'Angelo

"The desire to know is natural to good men" - Leonardo da Vinci
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform