> > Should I continue to archive my Orders and OrderItems or can I bring
> > these back together???


> I would personally not use this archive system. I have many
> instances of over a million records per table and with the
> right indexes you would never know it when reporting.

I completely agree!!

The correct use of indexes will result in optimal system performance,
without having to be concerned creating/managing the archive/unarchive
process.

We have a number of installations which have multi-million rows tables,
and system performance has not changed since the first day they started
using the system.

In fact, since the data is in a single table, the users can produce
reports for any period of time they want at any time -- without having
to run any special 'unarchive' function.


Sean