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:
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:
Correct Link for WebDNA Archives (2002)
Template Encryption (1998)
WebCatalog - Mac vs Linux (2000)
webmerchant/ Mac Auth. and CC refunds (1998)
RequiredFields template (1997)
[WebDNA] v7 Stress Test and Strange Behaviour (2012)
rotating thumbnails (1997)
authentication box not kicking in (2001)
Searching multiple fields from one form field (1997)
[ModDate] bis_repetita (2000)
State Coalition Approves Internet Sales Tax Plan (2002)
Summing a field full of numbers ... (1997)
counting characters and/or words (1997)
still having shipCost.db Problem (1997)
[WebDNA] Downloadable docs (2011)
Multiple Pulldowns (1997)
[input]?? (1998)
RE: Checkboxes to add to cart... (1998)
Zip Code Radius Search Tool (2003)
Includeform Error (2002)