mysql大字段大查询慢_mysql对于大字段的查询慢的处理

有两个表

create table e_question (

question_id char(32) not null,

topic_id char(32) null,

title varchar(1000) null,

answer varchar(500) null,

answer_analysis varchar(1500) null,

question_type varchar(50) null,

score numeric(20,2) null,

seq numeric(5,0) null,

institution_code varchar(50) null,

create_date varchar(20) null,

create_user varchar(50) null,

constraint PK_E_QUESTION primary key (question_id)

)

create table e_pick_topic (

pick_topic_id char(32) not null,

task_id char(32) null,

topic_id char(32) null,

institution_code varchar(50) null,

create_date varchar(20) null,

create_user varchar(50) null,

constraint PK_E_PICK_TOPIC primary key (pick_topic_id)

)

在表e_question有3个大字段，title, answer, anser_analysis,所以在关联查询的时候会很慢，如：