Ruslan,<div><br></div><div>Thanks for you feedback. I zipped the database and you are right...it goes from 30meg to 5meg which is great. Thanks for the clarification on the field sizes. I wasn't sure if the storage was fixed or variable depending on the length of the field in the database.</div>
<div><br></div><div>Have a wonderful weekend!</div><div><br></div><div>Warren</div><div><br></div><div><br></div><div> at 11:34 AM, Ruslan Zasukhin <span dir="ltr"><<a href="mailto:ruslan_zasukhin@valentina-db.com" target="_blank">ruslan_zasukhin@valentina-db.com</a>></span> wrote:<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 2/3/11 9:44 PM, "Warren Kuhl" <<a href="mailto:warrenkuhl@gmail.com" target="_blank">warrenkuhl@gmail.com</a>> wrote:<br>
<br>
Hi Warren,<br>
<div><div></div><div><br>
> I have a table which I created with 2 fields as varchar(2040). The table<br>
> contains around 40,000 records and the table takes up around 30 meg.<br>
> <br>
> Field 1 max length <= 100 characters (key field)<br>
> Field 2 max length <= 500 characters<br>
> <br>
> I am trying to get the table down in size from 30 meg. Would varchar be the<br>
> best way to store a field(s) of this size (or string...or ???)?<br>
> <br>
> ie. Field 1 = varchar(100); Field 2= varchar(500)<br>
<br>
</div></div>1)<br>
<br>
You will nothing actually making VarChar(100).<br>
This only will setup top-limit and will truncate strings.<br>
<br>
Bigger MaxLength do not eat more space.<br>
<br>
<br>
2)<br>
<br>
Why you think 30M is too much?<br>
What size of e.g. Your text file with same strings?<br>
<br>
Keep in mind that db file contains strings in UTF16.<br>
So this is compared to 15MB UTF8 may be.<br>
<br>
<br>
3) also what reason to fight with size?<br>
You need transfer that file?<br>
Try to make ZIP, I think you will be surprised.<br>
<br>
<br>
<br>
--<br>
Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
<br>
<br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</blockquote></div><br></div>