asked on

performance implication of using mediumtext over text in mysql

hi,
i have a mysql table with a column of type text. i want to change the type to mediumtext to support large amount of data.
what are the performance implications of the same.
will the queries be slow ?

thanks

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rohit Bajaj

ASKER

i read that text and mediumtext are both stored separately and not in the table only a pointer to that is stored in table...

how can i verify this on my own...
because when i do select from table
i see the whole text only in the ouput and not any pointer

Dave Baldwin

You can't easily verify it on your own. It is supposed to act like single field. The pointer is an internal function for the MySQL server, not for the user.

Rohit Bajaj

ASKER

ok. where exactly does mysql stores the text data...and what exactly happens when we query the table. how does it retrieve the data for text type columns or mediumtext type columns

SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Bernard Savonet

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bernard Savonet

Thx for the grade and points.