You cannot store 212345678901234567890123456.988290112 using IEEE a 8 byte
double precision. You cannot do this even with a 16 byte (long double - which
for x86 architectures is actually 80-bit extended precision - only 64 bit for
mantissa; is not the quadruple precision).
If you care about
it, but you are entering wild territory.
I'm a huge fan of SQLite, but I wouldn't use it for the job you described.
John
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Igor Conom
Sent: Saturday, October 17, 2009 10:10 AM
T
Sorry for the formatting - it looked better when I sent it from Yahoo's web
interface.
- Original Message
From: Igor Conom <igor..co...@yahoo.com>
To: sqlite-users@sqlite.org
Sent: Sat, October 17, 2009 9:03:54 AM
Subject: [sqlite] Creating a spatial index for a large number of
Hello everybody!
I need to create a spatial index for a
large number of points and I would really like to hear your comments.
Thank you in advance for your time.
There are some very large files containing scientific
data, stored in a very simple format (by very large I mean
things in the
4 matches
Mail list logo