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:
Configuring E-mail (1997)
ReturnRaw, download link for mov (2007)
RAM variables (1997)
Windows 2.1b2 Append Bug? (1997)
Help needed! (1998)
Duplicate Items in the Cart (1998)
Caching [include] files ... (1997)
Out of the woodwork (2007)
Setting up the server (1997)
[WebDNA] Was there ever a BeOS compatible version? (2009)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Requiring that certain fields be completed (1997)
cron script for housekeeping and running WebCatalog? (1999)
form posts expiring instantly... why? (2000)
form data submission gets truncated (1997)
Archives... (1997)
customizing the color of user's pages (1997)
emailer (1997)
[isfile] ? (1997)
Replace context problem ... (1997)