>Jim,
>
>The project I am developing is a simplified accounting software. At each month's end I need to move the the records (for example posted invoices , cash receipts etc) to history so the application can perform faster. So my moving of certain data to history is purely for performance reasons. If the user wants to take a look at the details of any of these records, I will pull them up from the history. I am of opinion that there are lot of applications which do end of month closing kinda activity and wanted to find out if there is a proven way of doing it instead of inventing one.
>
>Thanx
>Gnana

My US$.02

If you're archiving data "purely for performance reasons", there may be better ways of achieving better performance. VFP (as FPW did before it) can very quickly handle millions of records in tables of 1-2 gB size, if the code is well written to take advantage of Rushmore optimization.

Archiving data so that the "current" tables are smaller, so that VFP can handle the smaller tables more quickly, is a largely outdated concept.

Unless you're talking about tables which build up more than a million records a month.

Rich.