Thanks for the suggestion, of course we'll use them... I think we'll also need Cache 5.1 for the announced improvements of aggregation functions in queries, but since our reports are almost static (they are customized at the beginning), performance shouldn't be critical.
Max "Gershon Simcha" <[EMAIL PROTECTED]> ha scritto nel messaggio news:[EMAIL PROTECTED] > Hi Max > > Try to think of using bit map indexes (you can do it with simple mumps using > the $bit functions). > I did it just for the sake of olap and it was marvelous with speed & query > ability. > PS defining a good cache for globals an assuming that most of the olap > queries are the same you can rely on globals (bit mapped indexes) on speed. > Simcha > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/04 > >
