You are replying to:

1. • 
   • Dwight Wilbanks
   • Posted on Sun 5 Feb 2006 08:06 AM

   Heres mine.

   Column 1, sorted Categorized

   DT := @Date(EventDate);

   DT:

   @Adjust(DT;0;0;1;0;0;0):

   @Adjust(DT;0;0;2;0;0;0):

   @Adjust(DT;0;0;3;0;0;0):

   @Adjust(DT;0;0;4;0;0;0):

   @Adjust(DT;0;0;5;0;0;0):

   @Adjust(DT;0;0;6;0;0;0);

   Column 2, Sorted

   @Date(EventDate)

   Then just @dblookup on todays date.

   The big test for performance is the frequency of documents changing VS the data read frequency.

   An expensive view action can make sense when the data is not changing often and retrieved value is used often.

Your Comments