Web Wiz Forums - SQL 9.60 slower than 9.5x

Print Page | Close Window

SQL 9.60 slower than 9.5x

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27684
Printed Date: 02 April 2026 at 12:48pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL 9.60 slower than 9.5x

Posted By: Nick-V
Subject: SQL 9.60 slower than 9.5x
Date Posted: 13 August 2009 at 1:45am

I am using the latest version 9.60 but still also have the pages for MS SQL 9.56a installed so can do a direct comparison of the two versions against the same database.

Refreshing forum_topics.asp for a specific forum using 9.60 takes 0.312 seconds whereas with 9.56a it takes just 0.156 seconds.

Replies:

Posted By: Nick-V
Date Posted: 13 August 2009 at 1:50am

To add some info, the home page default.asp now takes 0.125 seconds instead of 0.047 seconds.

Could it be reading database records instead of using memory variables?

Posted By: 123Simples
Date Posted: 13 August 2009 at 11:38am

I have not noticed the time issues you mention nick but then I am only running 9.60 and connecting to the one database, rather than two forums connecting at the same time (which both will be if they are logged in at the same time)
Have you tried just running 9.60 on its own (without 9.56a) and then you could perhaps get a clearer idea of time loads

This page for example loaded in 0.063 seconds

Posted By: WebWiz-Bruce
Date Posted: 13 August 2009 at 12:02pm

There is nothing that would affect performance between 9.56a and 9.60 as the main difference is the new install wizard, but this have nothing to do with the way the pages in the forum run.

The forums home page and the forum_topics.asp pages have not been changed at all betwen 9.56a and 9.60.

No pages except a large search should take 3 seconds for a page to load. This and the differing load times indicate issues with server or network load rather than issues with in forum software.

You should look instead for bottle necks in CPU usage, Disk IO, memory, and if using remote SQL Server database the same on the database server as well as network load and database load.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Nick-V
Date Posted: 13 August 2009 at 1:23pm

Guys, I have done proper tests. I only reinstalled the old version when I noticed the decline in performance. I have one database on an otherwise quiet server. I have a \forum folder with the new version and now a \forumold folder with the old version so its easy to run side-by-side tests.

I installed the new version using the wizard as documented and did not edit the connection file manually.

Believe me, there is a consistent difference in performance between the two sets of ASP pages.

I am not suggesting its the pages themselves but perhaps the way the database is opened or the use of memory variables (not using them in the new version for some reason causing reads on the default.asp page).

Bruce, I have sent you two comparison URLs by PM (which I don't wish to provide publicly).

Posted By: Nick-V
Date Posted: 13 August 2009 at 1:36pm

Sorry...I have corrected the times stated in my first posting...decimal point in the wrong place....not 3 seconds but 0.3 seconds.

So...twice as long for forum_topics and nearly three times as long for default.asp.

In case it is relevant:

strDatabaseType = "SQLServer" '(2005)
strSQLServerName = "(local)"
blnSqlSvrAdvPaging = True

Posted By: Nick-V
Date Posted: 13 August 2009 at 2:40pm

Thanks for looking Bruce. I'll continue to monitor and delete the old version. The reason I investigated in the first place is that the times stood out as being quite a bit slower.

I have since fiddled and rebooted, in particular switching off logging on image folders and other unnecessary folders and this helps performance generally a little. It MIGHT account for the currently reduced difference between the versions here (less than twice at the moment).

I'd like to ask someone using the latest version to quickly put up a \forumold folder with the old version in it and to do a test on their server...although I acknowledge the limited programming changes made between versions I am not ready to believe I am the only one with this issue as my setup is so simple.

Lets bear it in mind and see...

Posted By: WebWiz-Bruce
Date Posted: 13 August 2009 at 2:45pm

There is no reason for a slower speed from 9.56a to 9.60 as there have been no changes to the code that would in anyway affect performance.

Have also in the lab placed a 9.56a version and a 9.60 version side by side on the same server using the same SQL Server 2008 database and can see no difference at all in speed with each forum returning identical times.

I suspect that the differences are to do with settings on the server, it could be to do with modifications that you may have made, how you have the application pools configurable. Even down to as far as how cookies are set.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting