Re: Deleting TPS Records Faster?

yshouldeye@[EMAIL PROTECTED]
 wrote in news:cdb66309-f2a7-4ff5-9ba4-10b7ce3d0521
@[EMAIL PROTECTED]
> 
>   I'm working with an application in Clarion 6.1 and I'm working on
> improving our archiving process in our program. It seems that the
> deleting of records is taking forever and some of our customers are
> complaining of archives taking 4+ hours to finish. Basically we
> archive all the users old records for a TPS file into a secondary TPS
> file and then delete the record from the main TPS file. Is there a
> better method to go about cleaning out a TPS file and archiving the
> old records into a seperate file? Thanks in advance for any help!
> 
> - Phillip

The fast way to arcive and delete files I have found is to use the same
metode as the 'convert' function do.:

- Read the old datafile and write all you want to keep to a new file.
- Delete the old file.
- Rename new file to the name off the old file.

All you need to do extra is to define a backup-datafile and write all
the record you 'delete' to the backup-file.
If you want to keep all bcakup records in a single file just appand the 
backup to the master backup.

You can easy do this from a stand-alone convert-project or include the
code in the main app.

regards
Kjetil Nesheim