> > okay, with gdb i can see that this column becomes a blob (thereby
> > not allowing heap tables to be used - which has got to be costing
> > me speed), is there any function i can use to 'cast' this column
> > to a fixed length?
>
> hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())), N) will do
> t
> okay, with gdb i can see that this column becomes a blob (thereby
> not allowing heap tables to be used - which has got to be costing
> me speed), is there any function i can use to 'cast' this column
> to a fixed length?
hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())), N) will do
that for me...
> any thoughts/suggestions?
>
> the only thing that's different is the SUBSTRING_INDEX(MAX(CONCAT()))
> construct, and i can't immediately see why that slows it down so
> much...
okay, with gdb i can see that this column becomes a blob (thereby
not allowing heap tables to be used - which has got
this is curious:
the table:
CREATE TABLE inbw_day_diffs_2001_Jan_02_10 (
hostname char(20) NOT NULL default '',
variable_name char(64) NOT NULL default '',
variable_index_value char(114) NOT NULL default '',
variable_index_label char(50) NOT NULL default '',
variable_result_value_numer
