Defining Fields

[Warren Kuhl]

I have a table which I created with 2 fields as varchar(2040).  The table
contains around 40,000 records and the table takes up around 30 meg.

Field 1 max length <= 100 characters (key field)
Field 2 max length <= 500 characters

I am trying to get the table down in size from 30 meg.  Would varchar be the
best way to store a field(s) of this size (or string...or ???)?

ie. Field 1 = varchar(100); Field 2= varchar(500)

Thanks for any input!
Warren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110203/4e0db5a8/attachment.htm>