[EMAIL PROTECTED] wrote:
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
What is going slower, INSERT / UPDATES or SELECTS?
Complex SELECTs
CHAR should make for quite efficient processing, since to a
large degree nobody cares what's in there: it just slams the
data in, or does a simple byte-by-byte comparison. There is
probably hardware support for that kind of operation. Decimal
arithmetic, on the other hand, requires more data
manipulations. The size of the column probably is outweighed
by the more complex data handling.
I am doing the following operations:
- Joins based on indexed columns
Did you change *all* columns involved in the joins?
Otherwise you have:
decimal joining to char
which mysql will need to convert internally to be the same type..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]