If I am not mistaken, you can configure Sqlite to not use floating point at
all. Divisions in such
an environment ought to be truncated integers without additional effort. But I
could be wrong.
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> I also think we should consider the use of SQLite in embedded
> application, many of which don't have hardware support for floating
> point math. In this environment, the conversions from integer to
> floating point and the use of floating point math could introduce
> significant performance penalties. In this case the user will almost
> certainly declare their columns as integer, and often desire integer
> math. With the proposed change sqlite will automatically convert the
> integer values to floating point and do a floating point divide, then
> the user will have to add additional SQL to truncate the floating point
> quotient back to an integer value in order to get the same effect as the
> current integer division. This extra work will take additional time.
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
