Memo Field一问# Database - 数据库
b*u
1 楼
常看见书上说应该避免用Memo/OLE object field。
可是SQL Server里Varchar can take up to.. 4000 or 5000?
forgot. 有的时候确实不够啊。而如果用text, give it a size
of 16 will takes care of any big block of text.
再说,如果我用两个4000的varchar,是不是即使我insert一个几乎
为空的record, the system will still allocate 8000+ space for
this record? While use text, maybe only 50 bytes?
Memo field到底不好在哪儿呢?I've read something like "for
memo fields, it saves a pointer in the table, and all the data
is actually saved somewhere else..." so what?
可是SQL Server里Varchar can take up to.. 4000 or 5000?
forgot. 有的时候确实不够啊。而如果用text, give it a size
of 16 will takes care of any big block of text.
再说,如果我用两个4000的varchar,是不是即使我insert一个几乎
为空的record, the system will still allocate 8000+ space for
this record? While use text, maybe only 50 bytes?
Memo field到底不好在哪儿呢?I've read something like "for
memo fields, it saves a pointer in the table, and all the data
is actually saved somewhere else..." so what?