Ben In addition to Denver's comments...
MAXLEN does not effect anything in the actual global storage What it does do is a) if you have TRUNCATE=1 (the default) then the string is chopped on storage - TRUNCATE=0 the string is saved in it's entirety b) used in ODBC projection to tell the ODBC client the size of the string c) CSP form wizard to construct the HTML form d) Probably something in Java Projection - but I don't do Java Peter On Tue, 04 May 2004 10:19:18 -0400, Ben Taylor <[EMAIL PROTECTED]> wrote: >Hi all >I am changing around some database structure and I have a question. I >know that Cache only allocates storage for the the actual amount of data > being stored, (aka string property with with value = "DD" and MAXLEN = >50 will not take up any more space than string property with with value >= "DD" and MAXLEN = 2). That is a good thing. >My question is, if I wanted to set MAXLEN = 32000 to allow full use of >the global node (I would like to not use the %Stream interface), how >would that affect performance? How does cache allocate memory for the >buffers? would it allocate enough memory to hold a 32k string when the >string stored may be <1k ? I'm not really sure how cache does this. Any >thoughts on this? > >Ben Taylor >MPLNet, Inc. >[EMAIL PROTECTED]
