> I am starting to convert a MS SQL 7 database to FB 1.5 and I am
> wondering if I should continue to use an archive type of table
> (ArchOrderItem) or can I now roll these records back into my main
> OrderItem?
>
> The reason I originally removed these records from the main OrderItem
> table was to increase the speed of queries and reports.
>
> At the end of each month, any orders which were completly paid, were
> then moved over to the ArchOrderItem table.
>
> Now, all this was done waaaay back in MS SQL 6 and 6.5 when SQL
> server was slow and the hardware running it was slower... by moving
> these records out of the main OrderItem table, it made reporting much
> faster... but it makes reporting MUCH more complicated! I often have
> to run two sets of reports to include the paid orders and the non-
> paid orders - this is confusing to users too!
>
> I currently have just over 1 million rows on the ArchOrderItem table
> and usually add about 50,000 each month. Our new server hardware has
> lots of RAM (1 or 2 GIG) and a decent processer.
>
> Should I continue to archive my Orders and OrderItems or can I bring
> these back together???
>
> Thanks for any ideas/help
> --Raymond

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