James Lyon writes:
> I will have a Primary Key of two fields -- an integer of some kind and a
> float of some kind.
>
> Thinking about the implementation in MySQL I wonder about a possible
> performance hit on certain kinds of floats. Do some sort/index/search
> faster than others?
>
> Ta,
> J.
>
Hi!
Performance of the float is a lesser problem. Larger problems are
comparisons involving = !! The problems stem from the obligatory
rounding errors. Are you sure that bigint attribute could not fullfill
the function ??
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
