Edwin A. Epstein, III wrote:

> I have a couple of databases with 20 million + rows in 2 or 3 tables linked
> by indexed double precision fields. I have not needed to link them with a
> foreign key constraint. I have PK's on double precision fields in each of
> the tables. As far as speed goes, lookups on 2 joined tables takes about
> 0.062 seconds. Fetching 10K-100K records at a time takes me about 8-30
> seconds.

Are you saying that you're using a floating point type for PK/FK? I
would have thought that floating point numbers would be inherently
problemativ for such purposes, considering they will suffer
truncations/round-off errors as soon as you pass the through some API
that uses a different floating point number format, or to/from string
format.

Or am I missing something?

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64