<div>
i read that text and mediumtext are both stored separately and not in the table only a pointer to that is stored in table...<br />
<br />
how can i verify this on my own...<br />
because when i do select from table<br />
i see the whole text only in the ouput and not any pointer
</div>


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


<div>
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
</div>


<div>
Thx for the grade and points.
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
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.<br />
what are the performance implications of the same. <br />
will the queries be slow ?<br />
<br />
thanks
</div>
</div>


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

performance implication of using mediumtext over text in mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.