Convert Visual Foxpro Memo field

[PRPhx]

Greetings!
I am starting a new project here at work. This project is a concersion of a box and record tracking program written in VFP 6.

The conversion will be done using SQL Server 2000 as a backend and vb.net as the front end. MY question is: What is the most efficient field type to use for the memo field9s). There are several memo fields in various foxpro tables. My largest table is well over 100,000 rows and I need to store the memo field9s) as efficiently as possible. The memo fields store descrptions of the files and records contained in each box.

Thanks for your advice, in advance.

 

[vongrunt]

There is not much choice - varchar or text, depending on max. data length in memo field.

If storage really matters you can create one-to-many "memo" table (PK + varchar column) and store each memo field value in as many rows as necessary.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)