Speed issue

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
3/12/2007 9:54:36 AM
FaithFux
Gravatar
Total Posts 17
View Posts

Speed issue

Hello again,

finally I got my MojoPortal working. Now I'm experiencing a speed issue. Accessing and navigating through the pages takes several minutes every time, so people start to ask if there is a web page anyway. :)

I sent an email to my provider asking whether there is a performance problem right now, but haven't received an answer so far.

I'm running MP on a medium trust environment.

 

BR,

Benjamin

3/12/2007 10:06:51 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Speed issue

This is the first ever report of any performance problem with mojoPortal so I'm reluctant to believe the code is at fault though I'm happy to try and help diagnose the problem.

Is the site public where I could see the performance?
Is there anything unusual in the /Data/currentlog.config file?

Is your host doing any resource throttling, ie limiting you to x MB of ram?
My best guess would be that this is whats happenning, your host is limiting you to x amount of ram or limiting the app pool to x amount of ram or the app pool is configured to restart if ram reaches x amount and x amount is not much.

Or it is possible that your site is running in an app pool with other sites and they are running code that is exhausting resources or constantly causing the app pool to recycle.

Hope it helps,

Joe
3/12/2007 10:17:30 AM
FaithFux
Gravatar
Total Posts 17
View Posts

Re: Speed issue

Hmm, the only thing I changed on the code so far is to move the W3C-Logos to a separate copyright site.

The URL is http://www.fdplinnich.de/

 

My host allows me to create up to 5 web application. So far I did not define one for MP since it was working anyway. Should I try to assign one to the MP directory?

Additionally it is very likely that resources assigned to every hosting package are limited, but it costs me over 30€ per month, so it should have sufficient RAM and CPU usage to run MP. :-)

3/12/2007 10:34:29 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Speed issue

It has an application or it would not work. I don't know whether changing settings on your host will fix it because I don't know what is causing it though I am 99% sure its a hosting issue since no-one else has ever reported a problem like this.

You did not answer whether there is anything in the log file of interest.

Other than resource starvation which could cause this, one other thing I've seen before that can cause this in web apps is if the db is on a different machine and there is some slowness in resolving the dns name for the db machine.

Both of these are issues to take up with your host.
3/12/2007 10:45:11 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Speed issue

One thing you can do to find out if the application is being restarted for every request, is edit the log4net.config file and set the level to INFO

This will make logging much more verbose but it will log the application start event, you would see this in the log:

Global.asax.cs Application_Start

If that is happening over and over for each request it will confirm that the application is being restarted for every request. That or slow connection to the db are the main things I can think of that would cause the symptom you are having.

Hope it helps,

Joe
3/12/2007 10:46:49 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Speed issue

I just got this error on your site which would seem to indicate a poor connection to the db:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
mojoPortal.Web.Global.HandleException(Exception ex) +438
mojoPortal.Web.Global.Application_Error(Object sender, EventArgs e) +94
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.HttpApplication.RaiseOnError() +182
3/12/2007 10:49:02 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Speed issue

I assume you have done something because now your site seems to be responding very well.

Joe
3/14/2007 2:31:56 AM
FaithFux
Gravatar
Total Posts 17
View Posts

Re: Speed issue

Hey Joe,

thanks for your help. I will suggest a review of DB connections to my host!

It seems that at night the page is responding normally. But yesterday evening I tried to invoke the admin panel. After I took the dogs for a walk, finished feeding the cat and picked up my little sister from her piano lesson it finally did apply changes (no timeout though!).

I have another hosting package for my personal website getting the same speed issue:

http://www.benjamin-toussaint.de/

When I'll be back in the company I'll download the error log!

 

Greetz,

Benny

3/14/2007 7:27:48 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Speed issue

Are both your sites at the same hosting company? I suspect you are just on a server that is packed full of sites.
What hosting company are you using?

Joe
3/21/2007 8:12:50 AM
FaithFux
Gravatar
Total Posts 17
View Posts

Re: Speed issue

I'm using 1 & 1, which is one of Germany's major web hosts and usually quite reliable.

I reported this issue and they have put an eye on database performance - didn't find anything though. They suggested to review the web.config file which might try to connect to another DB server first though.

This is an excerpt from my web.config :

<appSettings file="user.config">

<!-- Database Settings *************************************** -->

<add key="MSSQLConnectionString" value="server=mssql07.1und1.de;UID=[MY_DB_USER];PWD=[MY_DB_PASS];database=[MY_DB_NAME]" />

<!-- mojoProject is a feature currently under development, you do not need this connection string at this time -->
<add key="mojoProjectMSSQLConnectionString" value="server=mssql07.1und1.de;UID=[MY_DB_USER];PWD=[MY_DB_PASS];database=[MY_DB_NAME]" />
<!--
For using MS SQL set this to true for best performance
but if running the web on mono you may need to set this to false.
-->
<add key="CacheMSSQLParameters" value="true" />

<add key="MySqlConnectionString" value="Data Source=localhost;Database=mojoportal;User ID=mojouser;Password=mojo123" />

<!-- mojoProject is a feature currently under development, you do not need this connection string at this time -->
<add key="mojoProjectMySqlConnectionString" value="Data Source=localhost;Database=mojoportal;User ID=mojouser;Password=mojo123" />

<!-- pooling=true; Port=3306; min pool size=33;max pool size=66;Charset=latin1; -->

<add key="PostgreSQLConnectionString" value="Server=localhost;Port=5432;Encoding=unicode;User Id=mojouser;Password=mojo123;Database=mojoportal;Pooling=false" />

<!-- mojoProject is a feature currently under development, you do not need this connection string at this time -->
<add key="mojoProjectPostgreSQLConnectionString" value="Server=localhost;Port=5432;User Id=mojouser;Password=mojo123;Database=mojoportal;Pooling=false" />
<!--
Paramater caching is not yet supported in NpgsqlHelper; however,
PostgreSQLData is written in anticipation of taking advantage of this feature.
Keep value as False for now.
-->
<add key="CachePostgreSQLParameters" value="false" />

3/21/2007 8:37:10 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Speed issue

If there is a user.config file it will use the connection string from there in preference to the one in web.config.

However there is no fallback, if it can't connect using the one in user.config, it won't then try the one in web.config.

I have never heard of any performance issues relating to using a user.config file

If you are not using a user.config file you can remove the file=user.config but I really don't think that will have any impact at all.

If it is not efficiently resolving the host name mssql07.1und1.de that could cause performance  issues

Hope it helps,

Joe
You must sign in to post in the forums. This thread is closed to new posts.