Re: Using procedures to maintain derived data

Mike Aubury <mike@aubury.demon.co.uk> wrote: > >Their is always the posibility of not using calculated fields. >You could have the header record, not including any totals from the >details. >Then use a view (for convienience) to calculate the fields you want. I must confess that my experience with view performance has been disappointing to say the least. Maybe I just don't properly set them up, but views on tables the size of the ones I'm dealing with are agonizingly slow. -- Mike Lemon mdl@interpath.com