Re: Don't do this! (was: Crashing Type 3)

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25276
interpreted = N
texte = I assume that all 10,000 records are being displayed at once on one page. If so then simply stick a max=25 (or whatever will work), the use [shownext] tags on the bottom to create links to view each chunk of 25 of the total return results. >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 > ------------------------------------------------------------- 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:

    
  1. Re: Don't do this! (was: Crashing Type 3) (Joseph D'Andrea 1999)
  2. Re: Don't do this! (was: Crashing Type 3) (Brad Eisenberg 1999)
  3. Don't do this! (was: Crashing Type 3) (Joseph D'Andrea 1999)
I assume that all 10,000 records are being displayed at once on one page. If so then simply stick a max=25 (or whatever will work), the use [shownext] tags on the bottom to create links to view each chunk of 25 of the total return results. >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 > ------------------------------------------------------------- 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 Brad Eisenberg

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 : Site speed feedback (2002) Max Record length restated as maybe bug (1997) [WebDNA] Installing 6.0 onto Server 2008 (2011) absolute paths for databases? (1997) I'm tired of all this! (2000) Simple way to create unique SKU (1997) error (2000) Word Breaks (1998) WebCat2b13MacPlugIn - More limits on [include] (1997) Setting up WebCatalog with Retail Pro data (1996) Help name our technology! (1997) Aaron kant add (or whatever it was) (2000) Banners (1997) DON'T use old cart file! (1997) AppleScript question (1997) [WebDNA] HTTP Streaming -- impossible? (2010) woops - speed results - right subject (2002) Passing a search through a form (2003) my price won't move (1997) syntax question, not in online refernce (1997)