Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any studies on when PACKing really helps?
Message
From
27/12/2006 09:11:32
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01180412
Message ID:
01180462
Views:
15
>for tables without any memo fields:
>Was wondering if anyone knew at what precentage point deleted records casue a significant performance hit when doing SQL statements.
>Is it a basic standard or does it depend on the number of fields and/or type of fields.

Imho, they don't cause performance hit, because if SET DELETED ON, VFP will have to check for deleted records regardless if they are in a table or not.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform