Re: Slow Server

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62592
interpreted = N
texte = largest db is 45+ meg give or take. --- nitai@computeroil.com wrote: > Yes, we dont have any service called MSSQL or alike. > Do you also run 250MB DB's? Everything else runs > fast, just when it comes to this big DB everything > crawls :-( > > Nitai > > -- > Redakto CMS - Content Management that simply works > Redakto eServices - Professional WebHelpDesk > Redakto ImagePark - Innovative Asset Management > > ComputerOil® AG > Neugutstrasse 66 > 8600 Dübendorf / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://computeroil.com > > > ----- Original Message ----- > From: Lester > To: WebDNA Talk > Sent: Fri, 15 Jul 2005 21:40:24 +0200 > Subject: Re: Slow Server > > > > I feel your frustration. > > My "old" NT servers couple of years ago were 1/3 > as > > fast (LOL) when I changed hosts and went dedicated > > servers.... > > > > My old sites were crawling even though the new > > hardware was superior to the old NT servers. > > > > After we chased down that entry in "services" all > was > > lightning fast by comparison..... > > > > and again I'm not talking MS SQL Server...... > > > > > MSQLSERVER > > is what we changed in services..... > > that's all. > > > > > > > > --- nitai@computeroil.com wrote: > > > > > Pfff...we are running a very fast machine with 2 > GB > > > Ram and Version 6.x of WebDNA. OS is Windows > Server > > > 2003 WebEdition. > > > > > > It is very fast and all works fast too, but a > search > > > in the 200MB DB takes forever, meaning 30 > seconds > > > compared to the G5 with the same database and > the > > > search performs in 4 seconds. > > > > > > Nitai > > > > > > -- > > > Redakto CMS - Content Management that simply > works > > > Redakto eServices - Professional WebHelpDesk > > > Redakto ImagePark - Innovative Asset Management > > > > > > ComputerOil® AG > > > Neugutstrasse 66 > > > 8600 Dübendorf / Switzerland > > > Telefon +41 (0)844 44 55 66 > > > > > > info@computeroil.com > > > http://computeroil.com > > > > > > > > > ----- Original Message ----- > > > From: Lester > > > To: WebDNA Talk > > > > Sent: Fri, 15 Jul 2005 21:22:56 +0200 > > > Subject: Re: Slow Server > > > > > > > > > > Nothing specific done with IIS that I can > remember > > > > > > > > Since that mssql change all has been well, and > > > thats > > > > the only thing I believe we've changed. > > > > > > > > I'm still running vers 4.51 > > > > server has 1 gig ram > > > > > > > > > > > > > > > > --- nitai@computeroil.com wrote: > > > > > > > > > Thank you, but that is not it. We dont have > it > > > > > running. > > > > > > > > > > Still the server is slow. Is there maybe any > > > > > recommended settings for IIS? > > > > > > > > > > Nitai > > > > > > > > > > -- > > > > > Redakto CMS - Content Management that simply > > > works > > > > > Redakto eServices - Professional WebHelpDesk > > > > > Redakto ImagePark - Innovative Asset > Management > > > > > > > > > > ComputerOil® AG > > > > > Neugutstrasse 66 > > > > > 8600 Dübendorf / Switzerland > > > > > Telefon +41 (0)844 44 55 66 > > > > > > > > > > info@computeroil.com > > > > > http://computeroil.com > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > From: Lester > > > > > To: WebDNA Talk > > > > > > > > Sent: Fri, 15 Jul 2005 20:37:30 +0200 > > > > > Subject: Re: Slow Server > > > > > > > > > > > > > > > > Look in Services > > > > > > is MSSQLSERVER and the companion to it > > > enabled??? > > > > > > I'm doing this from memory, sorry) > > > > > > > > > > > > That was the reason mine was > c-r-a-w-l-i-n-g. > > > > > > (I don't MSSQL etc...) > > > > > > > > > > > > I do have mysql running within Plesk, but > > > that's > > > > > all > > > > > > OK) > > > > > > > > > > > > After I made MSSQLSERVER "manual start" > speed > > > was > > > > > > a-ok. > > > > > > > > > > > > I think it was somehow reaching the max > > > > > connections > > > > > > for some weird reason (5 ???) and it > brought > > > > > things > > > > > > down to a crawl after reaching that. > > > > > > > > > > > > No problems since... (well, few > anyways.....) > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- nitai@computeroil.com wrote: > > > > > > > > > > > > > I have disabled all services that we > dont > > > need. > > > > > Got > > > > > > > 2GB Ram installed. > > > > > > > > > > > > > > -- > > > > > > > Redakto CMS - Content Management that > simply > > > > > works > > > > > > > Redakto eServices - Professional > WebHelpDesk > > > > > > > Redakto ImagePark - Innovative Asset > > > Management > > > > > > > > > > > > > > ComputerOil® AG > > > > > > > Neugutstrasse 66 > > > > > > > 8600 Dübendorf / Switzerland > > > > > > > Telefon +41 (0)844 44 55 66 > > > > > > > > > > > > > > info@computeroil.com > > > > > > > http://computeroil.com > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > From: WebDNA Talk > > > > > > > [mailto:WebDNA-Talk@talk.smithmicro.com] > On > > > > > Behalf > > > > > > > Of > > > > > > > > WebDNA Talk-List Admin > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Slow Server ( nitai@computeroil.com 2005)
  2. Re: Slow Server ( Stuart Tremain 2005)
  3. Re: Slow Server ( nitai@computeroil.com 2005)
  4. Re: Slow Server ( Gary Krockover 2005)
  5. Re: Slow Server ( Gary Krockover 2005)
  6. Re: Slow Server ( nitai@computeroil.com 2005)
  7. Re: Slow Server ( Lester 2005)
  8. Re: Slow Server ( nitai@computeroil.com 2005)
  9. Re: Slow Server ( Lester 2005)
  10. Re: Slow Server ( nitai@computeroil.com 2005)
  11. Re: Slow Server ( Lester 2005)
  12. Re: Slow Server ( Lester 2005)
  13. Re: Slow Server ( nitai@computeroil.com 2005)
  14. Re: Slow Server ( Lester 2005)
  15. Re: Slow Server ( nitai@computeroil.com 2005)
  16. Re: Slow Server ( "WebDNA Talk-List Admin" 2005)
  17. Slow Server ( nitai@computeroil.com 2005)
largest db is 45+ meg give or take. --- nitai@computeroil.com wrote: > Yes, we dont have any service called MSSQL or alike. > Do you also run 250MB DB's? Everything else runs > fast, just when it comes to this big DB everything > crawls :-( > > Nitai > > -- > Redakto CMS - Content Management that simply works > Redakto eServices - Professional WebHelpDesk > Redakto ImagePark - Innovative Asset Management > > ComputerOil® AG > Neugutstrasse 66 > 8600 Dübendorf / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://computeroil.com > > > ----- Original Message ----- > From: Lester > To: WebDNA Talk > Sent: Fri, 15 Jul 2005 21:40:24 +0200 > Subject: Re: Slow Server > > > > I feel your frustration. > > My "old" NT servers couple of years ago were 1/3 > as > > fast (LOL) when I changed hosts and went dedicated > > servers.... > > > > My old sites were crawling even though the new > > hardware was superior to the old NT servers. > > > > After we chased down that entry in "services" all > was > > lightning fast by comparison..... > > > > and again I'm not talking MS SQL Server...... > > > > > MSQLSERVER > > is what we changed in services..... > > that's all. > > > > > > > > --- nitai@computeroil.com wrote: > > > > > Pfff...we are running a very fast machine with 2 > GB > > > Ram and Version 6.x of WebDNA. OS is Windows > Server > > > 2003 WebEdition. > > > > > > It is very fast and all works fast too, but a > search > > > in the 200MB DB takes forever, meaning 30 > seconds > > > compared to the G5 with the same database and > the > > > search performs in 4 seconds. > > > > > > Nitai > > > > > > -- > > > Redakto CMS - Content Management that simply > works > > > Redakto eServices - Professional WebHelpDesk > > > Redakto ImagePark - Innovative Asset Management > > > > > > ComputerOil® AG > > > Neugutstrasse 66 > > > 8600 Dübendorf / Switzerland > > > Telefon +41 (0)844 44 55 66 > > > > > > info@computeroil.com > > > http://computeroil.com > > > > > > > > > ----- Original Message ----- > > > From: Lester > > > To: WebDNA Talk > > > > Sent: Fri, 15 Jul 2005 21:22:56 +0200 > > > Subject: Re: Slow Server > > > > > > > > > > Nothing specific done with IIS that I can > remember > > > > > > > > Since that mssql change all has been well, and > > > thats > > > > the only thing I believe we've changed. > > > > > > > > I'm still running vers 4.51 > > > > server has 1 gig ram > > > > > > > > > > > > > > > > --- nitai@computeroil.com wrote: > > > > > > > > > Thank you, but that is not it. We dont have > it > > > > > running. > > > > > > > > > > Still the server is slow. Is there maybe any > > > > > recommended settings for IIS? > > > > > > > > > > Nitai > > > > > > > > > > -- > > > > > Redakto CMS - Content Management that simply > > > works > > > > > Redakto eServices - Professional WebHelpDesk > > > > > Redakto ImagePark - Innovative Asset > Management > > > > > > > > > > ComputerOil® AG > > > > > Neugutstrasse 66 > > > > > 8600 Dübendorf / Switzerland > > > > > Telefon +41 (0)844 44 55 66 > > > > > > > > > > info@computeroil.com > > > > > http://computeroil.com > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > From: Lester > > > > > To: WebDNA Talk > > > > > > > > Sent: Fri, 15 Jul 2005 20:37:30 +0200 > > > > > Subject: Re: Slow Server > > > > > > > > > > > > > > > > Look in Services > > > > > > is MSSQLSERVER and the companion to it > > > enabled??? > > > > > > I'm doing this from memory, sorry) > > > > > > > > > > > > That was the reason mine was > c-r-a-w-l-i-n-g. > > > > > > (I don't MSSQL etc...) > > > > > > > > > > > > I do have mysql running within Plesk, but > > > that's > > > > > all > > > > > > OK) > > > > > > > > > > > > After I made MSSQLSERVER "manual start" > speed > > > was > > > > > > a-ok. > > > > > > > > > > > > I think it was somehow reaching the max > > > > > connections > > > > > > for some weird reason (5 ???) and it > brought > > > > > things > > > > > > down to a crawl after reaching that. > > > > > > > > > > > > No problems since... (well, few > anyways.....) > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- nitai@computeroil.com wrote: > > > > > > > > > > > > > I have disabled all services that we > dont > > > need. > > > > > Got > > > > > > > 2GB Ram installed. > > > > > > > > > > > > > > -- > > > > > > > Redakto CMS - Content Management that > simply > > > > > works > > > > > > > Redakto eServices - Professional > WebHelpDesk > > > > > > > Redakto ImagePark - Innovative Asset > > > Management > > > > > > > > > > > > > > ComputerOil® AG > > > > > > > Neugutstrasse 66 > > > > > > > 8600 Dübendorf / Switzerland > > > > > > > Telefon +41 (0)844 44 55 66 > > > > > > > > > > > > > > info@computeroil.com > > > > > > > http://computeroil.com > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > From: WebDNA Talk > > > > > > > [mailto:WebDNA-Talk@talk.smithmicro.com] > On > > > > > Behalf > > > > > > > Of > > > > > > > > WebDNA Talk-List Admin > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Lester

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:

WebCat2b13 Command Reference Doc error (1997) Re:Help name our technology! (1997) Appending Information from one db to another (1998) Multiple Pulldowns (1997) How do you hide [math]stuff[/math] (1997) Problems appending to database (1997) [WebDNA] An unknown error occured // Deadlock avoided (2011) Pithy questions on webcommerce & siteedit (1997) New index for docs (1997) Webcatalog, Webstar and Crasharama (1999) WebDNA-Talk Digest mode broken (1997) Applescript in Webcatalog problem (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) can WC render sites out? (1997) Who owns the code? (2002) Emailer (1997) 2nd WebCatalog2 Feature Request (1996) [ShowCart] and GET vs. POST (1997) Searchable Archive: Sender? (1998) [WebDNA] CRC-16-CCITT (2008)