Re: Webservice running very slowly


"Mr. Arnold" <MR. Arnold@xxxxxxxxxx> wrote in message
news:uZ3GVRVWIHA.5984@xxxxxxxxxxxxxxxxxxxxxxx

"John" <nospam@xxxxxxxxxx> wrote in message
news:fmnc8e0r0t@xxxxxxxxxxxxxxxxxxxx
Sorry, yet another post...

http://www.careware.com.au/Webserver%20-%20Application%20login%20(3%20webservice%20calls,%202%20small%20ones%20and%20one%20that%20downloads%20a%20large%20cache).jpg

Here is a image of perfmon, this was taken over about 6 minutes with 5sec
intervals and is a capture of the application logging in, 3 calls are
made to the webservice, 2 small, 1 large to download a cache....

Looking at this it makes me think that its my client application that has
issues...

There is currently very little load on the server because everyone has
gone home...

I dont get it :(

Anyone got any tips on the correct counters to be using...

Thank you for anyone who spends the time to look at this...
John

I think one of your problem could be the Access database. Access is not a
multi client solution and it could be an issue with speed. Access is not
an Enterprise database solution.


http://www.sql-server-performance.com/tips/asp_sql_server_p1.aspx
http://www.aldex.co.uk/sqlupsizing.html


If nothing else, SQL Server Express or MySQL are better solutions for an
Enterprise solution if one doesn't have a production server running full
SQL Server.



Yeah :( ooooh baby would i love to remove access in more way than you can
imagine......Unfortunatly that is a far off dream because the project is a
migration of the access application and its still in use. Unfortunatly its
not an option at this stage. We will be going to mySQL when we can. 6 months
from now hopefully.

What is actually currently perplexing me is that if I run the application in
debug mode on my dev computer, it runs reasonably decently, not fast, but
acceptable. As soon as I do it in release mode the perfomance drops in
several orders of magnitude. Then when I deploy it, it seems to sometimes be
slow and sometimes be mega slow. Sorry I know thats not exactly quantifying
things well....

Could this be because one of the policy files is not being copied to the
release or something like that, or an issue with compression.
The screen shot posted, was from a deployed version running through ADSL
1500/256, with the server running on no load.

Im showing my newbishness here as well with this question...
The WSE, does that need to have the wse runtime installed on the client....i
havent installed that on the client (I dont think thats the issue, but,
because im having so much trouble finding the cause, im guessing theres 2
issues and im getting confused)

Thank you MR Arnold for you ideas, I will look into the MS-Access and see if
thats causeing the issue...hmm although if it was.... wouldnt my local
network connection just hmmm..*** i need to take a break from this i
think....start from scratch...

Thanks heaps Mr Arnold for your ideas and help...very much appreciated...
John


.