Re: Database field limit?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16876
interpreted = N
texte = On 4/3/1998 7:24 PM, PCS Technical Support so noted...>>Is there a limit (in either character count or memory used) to the amount >>of information which can be used in a single database field? I have a >>case where a lookup returns a sometimes sizable chunk of HTML from a >>database and there's been problems with the webserver crashing >>immediately after (I'm using the plug-in, more than enough memory >>assigned for the database in question). > >How sizeable are we talking here? I've seen 300K go out from WebCatalog on >a single HTML page before. There are no built-in limits to the database, >so I can only imagine that perhaps W* is freaking at the huge amount of >data.The database itself is 25 meg, but the individual records that are being looked up and added to the page are only about 4 - 6K each. We're running WebTen and see odd things in the Access Log after the crash (ie: five or so lines of the database being searched appear verbatim in the log!) The problem may be tied into what the page is trying to do. Essentially, if a certain condition is met, the bulk of the page is hidden and a different page shown instead (via an Include). Right now I'm working on a different way of handling the page : )Rob Marquardt Designer/Resident Wirehead Toast Design300 First Avenue North, Suite 150 Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com
Associated Messages, from the most recent to the oldest:
On 4/3/1998 7:24 PM, PCS Technical Support so noted...>>Is there a limit (in either character count or memory used) to the amount >>of information which can be used in a single database field? I have a >>case where a lookup returns a sometimes sizable chunk of HTML from a >>database and there's been problems with the webserver crashing >>immediately after (I'm using the plug-in, more than enough memory >>assigned for the database in question). > >How sizeable are we talking here? I've seen 300K go out from WebCatalog on >a single HTML page before. There are no built-in limits to the database, >so I can only imagine that perhaps W* is freaking at the huge amount of >data.The database itself is 25 meg, but the individual records that are being looked up and added to the page are only about 4 - 6K each. We're running WebTen and see odd things in the Access Log after the crash (ie: five or so lines of the database being searched appear verbatim in the log!) The problem may be tied into what the page is trying to do. Essentially, if a certain condition is met, the bulk of the page is hidden and a different page shown instead (via an Include). Right now I'm working on a different way of handling the page : )Rob Marquardt Designer/Resident Wirehead Toast Design300 First Avenue North, Suite 150 Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com
Rob Marquardt
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[OT] Be Nice to Your Computer Wizards (2000)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
email preferences on NT (1997)
Nested vs conditional (1997)
Purchae error - Fixed to a degree (1997)
Some Advise needed (1997)
[WebDNA] Downloadable docs (2011)
[WebDNA] orderfile - encrypt test request (2011)
OT: Making demo movies (2002)
Physical Security for WebCatalog Directories (1997)
Resume Catalog ? (1997)
Max Record length restated as maybe bug (1997)
RE: Tax and ShipCost Problem (1997)
insecuretextvars preference doesn't work (2000)
[BoldWords WordList]Any Text[/BoldWords] (2000)
Using Currencies other than Dollars (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Multiply prices (1997)
Using [Include] Context (1999)
ShowNext Context (2004)