MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Performance
Posted by: Daniel Nichter
Date: May 23, 2005 07:32AM

I don't think there is any performance difference. LONGTEXT only uses as much storage as needed to hold the data, same as VARCHAR. One notable difference is that indexes on TEXT columns require a prefix length; VARCHAR columns do not.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Performance
2041
jan.schubert
May 20, 2005 11:05AM
Re: Performance
1460
Daniel Nichter
May 23, 2005 07:32AM
Re: Performance
1452
jan.schubert
May 26, 2005 04:36AM
Re: Performance
1401
Ulf Wendel
June 17, 2005 05:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.