Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - SQL 9.60 slower than 9.5x
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL 9.60 slower than 9.5x

 Post Reply Post Reply
Author
Nick-V View Drop Down
Senior Member
Senior Member


Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nick-V Quote  Post ReplyReply Direct Link To This Post Topic: SQL 9.60 slower than 9.5x
    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.



Edited by Nick-V - 13 August 2009 at 1:34pm
Back to Top
Nick-V View Drop Down
Senior Member
Senior Member


Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nick-V Quote  Post ReplyReply Direct Link To This Post 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?



Edited by Nick-V - 13 August 2009 at 2:06am
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.


Edited by WebWiz-Bruce - 13 August 2009 at 12:07pm
Back to Top
Nick-V View Drop Down
Senior Member
Senior Member


Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nick-V Quote  Post ReplyReply Direct Link To This Post 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).



Edited by Nick-V - 13 August 2009 at 2:12pm
Back to Top
Nick-V View Drop Down
Senior Member
Senior Member


Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nick-V Quote  Post ReplyReply Direct Link To This Post 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:

  1. strDatabaseType = "SQLServer"          '(2005)
  2. strSQLServerName = "(local)"
  3. blnSqlSvrAdvPaging = True



Edited by Nick-V - 13 August 2009 at 1:44pm
Back to Top
Nick-V View Drop Down
Senior Member
Senior Member


Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nick-V Quote  Post ReplyReply Direct Link To This Post 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...

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.