On 2006-01-20, at 01:13, Tucker Cunningham wrote:
So, my question is: what are the pros and cons of using varchar vs. text/longtext? Right now, longtext seems to be the best option (it provides most flexibility in data that can be stored, at only a 2-byte-per-row storage premium) There must be some drawback, what am I missing? Thanks for your help
Using VARCHAR instead of LONGTEXT for no reason you misinform the
optimizer giving it less data to reason out how to go about to perform
faster calculations and give you results You (or your program) - that
is data - expect. Think of it as reverse EXPLAIN.
--
Seks, seksić, seksolatki... <uri: news:pl.soc.seks.moderowana > ,
<http://www.okcupid.com/tests/take?testid=7062295162911411482 > ,
If you could only see what love has made of me, I'd... { (.A.)' }
no longer be in *your* mind the mind the difficult kind...{ A.A }
smime.p7s
Description: S/MIME cryptographic signature
