Don't do this! (was: Crashing Type 3)
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25274
interpreted = N
texte = I forgot to post a solution that I found to my crashing problem... On Saturday, I reported that I uploaded a new version of my site with some extensive changes to the WebDNA code. I had fully tested out the site on a development server and only expereinced the crashing when running on the real server. I suspected that the crashing (type 2 and 3) was due to the traffic load that was on my real server vs. my development server.That was not true.The problem is that I also changed one preference in the meantime. You see my members database has over 10,000 records in it. So I changed the maximum found items to return preference to 10,000. I did this, because I do have a few admin searches where I do want to be able to search for and return and do something with all the records in the database.Apparently, some users were able to hit one of the search pages and search for say a in a UserName and the amount of returned items was crashing the server.Changing the maximum found items down to a number like 500 has solved the crashing problem completely. (This was on Sunday that I made that change).So this begs a number of questions.Considering that the total database size is less then 3MB and that w* never reported less then 45 MB avaliable and since there is still another 80 MB left of RAM for the system to consume.... (ie... there's till plenty of memory available.)1) Why did the server crash?2) What if I really want to return 10,000 records?3) Waht if I want to return more records... my database is growing at ~200 records per day.3) What am I missing here?Thanks, ___Joe____________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.com/ _________________________________________________ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
I forgot to post a solution that I found to my crashing problem... On Saturday, I reported that I uploaded a new version of my site with some extensive changes to the WebDNA code. I had fully tested out the site on a development server and only expereinced the crashing when running on the real server. I suspected that the crashing (type 2 and 3) was due to the traffic load that was on my real server vs. my development server.That was not true.The problem is that I also changed one preference in the meantime. You see my members database has over 10,000 records in it. So I changed the maximum found items to return preference to 10,000. I did this, because I do have a few admin searches where I do want to be able to search for and return and do something with all the records in the database.Apparently, some users were able to hit one of the search pages and search for say a in a UserName and the amount of returned items was crashing the server.Changing the maximum found items down to a number like 500 has solved the crashing problem completely. (This was on Sunday that I made that change).So this begs a number of questions.Considering that the total database size is less then 3MB and that w* never reported less then 45 MB avaliable and since there is still another 80 MB left of RAM for the system to consume.... (ie... there's till plenty of memory available.)1) Why did the server crash?2) What if I really want to return 10,000 records?3) Waht if I want to return more records... my database is growing at ~200 records per day.3) What am I missing here?Thanks, ___Joe____________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.com/ _________________________________________________ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Joseph D'Andrea
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:
WebCat2 as a chat server? (1997)
"top" Clarification ( for apache ) (2008)
Image Pirating [protecting against] (2003)
More on the email templates (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
OT: Forcing a header when printing web pages (2002)
Referrer field to header field conversion (1997)
WebCat2b15MacPlugin - showing [math] (1997)
SiteEdit Pro (2000)
Appendfile memory usage (redux) (2003)
Error & Problem (1997)
Associative lookup style? + bit more (1997)
WCS Newbie question (1997)
[WebDNA] Search Site (2009)
[WebDNA] Hmmm ... (2008)
More WebMerch<->MacAuthoriz (1997)
Include a big block of text (1997)
Email encryption (1998)
Using Plug-In while running 1.6.1 (1997)
Date format problems (1997)