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
