Re: [ADMIN] History Tables Vs History Field

2004-03-09 Thread Erwin Brandstetter
Bart McFarling wrote: > I have a table that will recieve about 2000 inserts per day, > Although it will technically never be dead data, about 99.999% of > it will be uninteresing after 30-40 days, My problem is that I > dont know if I should create a new table that is a history table > or add a

Re: [ADMIN] History Tables Vs History Field

2004-03-11 Thread Paul BREEN
> I have a table that will recieve about 2000 inserts per day, Although > it will technically never be dead data, about 99.999% of it will be > uninteresing after 30-40 days, My problem is that I dont know if I > should create a new table that is a history table or add a indexed field > and ignor