Slow loading Dashboard

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Slow loading Dashboard

Post by efficiondave » Wed Jun 04, 2014 6:52 am

For one of my AbleCommerce sites (running 7.0.7), the admin Dashboard is loading really slow on occasion. I was hoping moving to a new faster server would resolve the issue but I did the move yesterday and just now it took 42 seconds for it to load. We see similar slow times more often than we should. I did see several instances of a Deadlock error that seem to relate to the slow load times. The error from the app.log is below. I don't believe I'm seeing anything like this on other AbleCommerce sites we host on the same servers. The one difference on this site is it is an application within a DNN site. But there doesn't seem to be any load time issues with any other pages.

Any idea what might be causing this?

System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at CommerceBuilder.Data.Database.a(DbCommand A_0)
Last edited by efficiondave on Wed Jun 04, 2014 8:03 am, edited 1 time in total.

crazyjoe
Commander (CMDR)
Commander (CMDR)
Posts: 172
Joined: Mon Apr 26, 2010 2:20 pm

Re: Slow loading Dashboard

Post by crazyjoe » Wed Jun 04, 2014 7:43 am

We had this exact same issue. My company was using Firefox to do all of our Able admin duties and just recently changed to Google Chrome and everyone (on macs and pc's) saw a dramatic increase in speed. Try that out.
Crazy Joe Sadloski
Webmaster
Hot Leathers Inc.
http://www.hotleathers.com

User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Re: Slow loading Dashboard

Post by efficiondave » Wed Jun 04, 2014 7:53 am

I looked into this a bit further and the error that is being thrown comes from SQL Server and is likely due to a long running query that needs to have an Index added to speed it up and prevent the deadlock. It makes sense that the server move didn't have an impact as we only moved the site files and not the database.

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2647
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Slow loading Dashboard

Post by Katie » Wed Jun 04, 2014 12:53 pm

This post is older, but I think it will still work if you want to profile the database and see if adding any indexes can improve performance.

viewtopic.php?f=42&t=17625&p=75890&hili ... rd+#p75890
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Slow loading Dashboard

Post by jmestep » Thu Jun 05, 2014 3:43 am

I had seen the problem on a site with many, many orders, customers, page views so I took some of the reporting widgets off the admin dashboard and page loads fine now. There was just a large amount of data to churn through. In Gold the reports are in a tab on the dashboard and they don't load until you click the tab.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply