>Traditionally I have handled by data files as .dbf. i.e. when adding records I would use append, when deleting I would delete and pack.
>
>I am now in a project where the data file could be very large in the order of 100,000 records. I am aware that delete/pack starts to become very time consuming with large data files.
>
>I have never used Select SQL for my data management. Would the various features of Select SQL permit deleting records more quickly than delete/pack ?
>
>Mike Smith
As Marcia writes, PACK is not meant to be used every time you delete a single record - or even multiple records.
In a multi-user environment, this is not even possible, 'cause you need exclusive access to use PACK.
Just use SET DELETED ON, to hide the deleted records.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)