List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:January 22 2000 1:58pm
Subject:Re: Non-integer Index performance choice
View as plain text  
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       |
+----------------------------------------------------------------------+
Thread
Non-integer Index performance choiceJames Lyon22 Jan
  • Re: Non-integer Index performance choicesinisa22 Jan