Hey Kirk, Yea I have been mulling as a possibility. But I really want to put 4D through it’s motions first. Not worried about storage at this time as this is kind of a laboratory for testing large tables.
Thanks for your ideas! John... > If absolute raw speed is what you are looking for I would break each value > into whole numbers - the integer and the decimal and store them separately > as longints. Index the integer with a b-tree and the decimal with a > cluster. You sacrifice space (maybe - haven't really done the math on 2 > longs vs 1 real) but space is cheap and you want speed. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
