>
> > > 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.

While I would mostly agree with this, I prefer to use fiscal year archives.
I have developed the simple code necessary to do multi-database queries that
let my reports span any time period needed. I use a simple table in the main
database that holds the names of each archive database the system has
created. I can then simply create the queries from each one.

I am currently working to finalize a multi-database join component (however
it is using TIBxxx components) that makes it even easier to access data
across databases. At this time, it will only do simple joins of like queries
across the databases. I hope to expand this later to create true joins from
tables in different databases. Using the code I created for my reporting
techniques that compares the records from each database to select the next
one based on sorting, I hope to have it done soon. I will post it on my
website as freeware when I finish.

Woody (TMW)
Freeware Page: http://users.eonet.net/woodytmw

All computers wait at the same speed.