Re: Performance Settings
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30733
interpreted = N
texte = on 4/20/00 10:11 PM, Charlie Romero at charlie@jumpinternet.com wrote:> Alex,> > Some searches just use a lot of CPU time. Are you sure you aren't> exhausting your machine. Asking it to do two things at the same time> may be too much. StarNine has that load tester app. Why don't you> give that a try and see whether you are using all your muscle. If you> are then you don't have much of a choice other than switching servers> or OS's.Charlie, You are right of course about using the machine. I have used the loadtester app and the machine serves admirably. I am 100% certain that were arenot using a trickle when it comes to connections.However, WebCat causes noticeable slow downs during these 3-5 secondsearches (and I do mean dramatic). I thought of spawning to free themachine, but the user needs to see the results so that was out.So in order to lessen the impact I did two things.1. Recoded the searches to dramatically reduce their returns (max found).This wasn't my first choice but since I was doing recursive searching 3levels deep, it had a dramatic impact on performance.2. Adjusted the settings as I mentioned to try to make the machine (G3 300198 ram) more responsive during WebCat functions. I have some other webcatfunctions (listfiles) that can be pretty unruly.But, as far as what other problems I could have started by taking thosesettings to the degree I did, I don't know. I hate not knowing!I currently have about 80 databases open at a time ranging from a few k to10 megs. Their field counts range from 2 to 100. My question revolved aroundwhat I was doing to all of them by fixing this 1 issue.Unfortunately it seems SM is the only one that can answer this.Thanks though.AJM-- -------------------------------------------------------------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:
on 4/20/00 10:11 PM, Charlie Romero at charlie@jumpinternet.com wrote:> Alex,> > Some searches just use a lot of CPU time. Are you sure you aren't> exhausting your machine. Asking it to do two things at the same time> may be too much. StarNine has that load tester app. Why don't you> give that a try and see whether you are using all your muscle. If you> are then you don't have much of a choice other than switching servers> or OS's.Charlie, You are right of course about using the machine. I have used the loadtester app and the machine serves admirably. I am 100% certain that were arenot using a trickle when it comes to connections.However, WebCat causes noticeable slow downs during these 3-5 secondsearches (and I do mean dramatic). I thought of spawning to free themachine, but the user needs to see the results so that was out.So in order to lessen the impact I did two things.1. Recoded the searches to dramatically reduce their returns (max found).This wasn't my first choice but since I was doing recursive searching 3levels deep, it had a dramatic impact on performance.2. Adjusted the settings as I mentioned to try to make the machine (G3 300198 ram) more responsive during WebCat functions. I have some other webcatfunctions (listfiles) that can be pretty unruly.But, as far as what other problems I could have started by taking thosesettings to the degree I did, I don't know. I hate not knowing!I currently have about 80 databases open at a time ranging from a few k to10 megs. Their field counts range from 2 to 100. My question revolved aroundwhat I was doing to all of them by fixing this 1 issue.Unfortunately it seems SM is the only one that can answer this.Thanks though.AJM-- -------------------------------------------------------------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
Alex McCombie
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:
2.0 Info (1997)
Re:multiple digests, please stop (1997)
Document Contains No Data! (1997)
Problem (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
Hiding HTML and page breaks (1997)
Passing Variables to a [shell scriptid=123][/shell] context (2004)
$flushdatabases question ... (1998)
Why don't Typhoon & Firesite work together? (and webcat) (1998)
Cold Fusion Buster (1997)
[sendmail] on NT? (1997)
Dynamic PDFs? (2004)
[SearchString] problem with [search] context (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Frames and WebCat (1997)
WCS Newbie question (1997)
Help with dates (2001)
FW: WebDNA-Talk searchable? (1997)
$Append for Users outside the ADMIN group (1997)
Modtime bug? (2002)