Memo Field vs. OLE Obj

[Aaron Bertrand - MVP]

> is there any appreciable difference between using a field

> of type Memo or an OLE object (say, an .rtf file)?

If it's just TEXT, use Memo (or better yet, store the RTF file in the file
system). Storing an OLE object requires much more overhead, and wastes
valuable space inside the database -- which is much cheaper and faster on
the file system.

[MDW]

Actually, I don't have all that much control on the server
file system as it is. And yes, it is just text. Thanks for
the input.

>-----Original Message-----

>> is there any appreciable difference between using a

field

>> of type Memo or an OLE object (say, an .rtf file)?

>
>If it's just TEXT, use Memo (or better yet, store the RTF

file in the file

>system). Storing an OLE object requires much more

overhead, and wastes

>valuable space inside the database -- which is much

cheaper and faster on

>the file system.
>
>
>.
>