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