From: Ann W. Harrison
Date: December 15 2008 5:54pm
Subject: Re: Falcon Index Keys
List-Archive: http://lists.mysql.com/falcon/314
Message-Id: <494699E1.6010201@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 7BIT

Vlad,
> 
> I think I would not map all numbers to double though if I'd be doing that
> from scratch ;) , it is a strange imprecise format.
> 

Imprecise, perhaps, but repeatable.  And it has two advantages:  first,
the trailing digits are not significant, so it can benefit from suffix
compression, and second, in systems that allow columns to be altered
in place, it avoids index rebuilds when either precision or the number
of decimal digits change.


Best,

Ann