Slow SQL performance
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=17986
Printed Date: 13 April 2026 at 7:32pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Slow SQL performance
Posted By: kiklop
Subject: Slow SQL performance
Date Posted: 16 January 2006 at 1:10pm
|
I decided to finally convert my access driven applications to SQL server.
Prior to convert "official" forum application I made a forum copy and transferred it to SQL (using instructions provided by boRg worked great). However, the performance is quite slower on sql version than on access one. Here is the current official forum www.dyxum.com/dforum/ and the new created copy on SQL server www.dyxum.com/xforum/ (not active of course) Now my question: is the low SQL server performance that is causing SQL version to run slowly (I'm using hosting company)? Is there anything I can do to optimise performance or should I search for other hosting service ? Thanks ------------- http://www.dyxum.com" rel="nofollow - dyxum.com |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 16 January 2006 at 5:20pm
|
Seemed to load in about the same speed to me, but as you have disabled the process time from the bottom of the pages it hard to tell if there is any difference in the generation of the page time. SQL Server version can be slow for a number of reasons, it could be that the SQL Server is overloaded, could be that the network is running slow and it's taking time to connect between the web server and the SQL Server. It could be a temporary cglitch with your web host, so maybe worth contacting them about it and see if it clears up. ------------- 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: kiklop
Date Posted: 16 January 2006 at 5:44pm
Ah, i have forget to enable this (now enabled for both forums and the difference is evident)
Thank you. I never worked with MS SQL server before (quite expensive in my country) but i was expecting to see at least the same performance as with access. I still waiting for the answer from my host company. Once again, thank you for taking the time answering. ------------- http://www.dyxum.com" rel="nofollow - dyxum.com |
-boRg- wrote:Posted By: WebWiz-Bruce
Date Posted: 16 January 2006 at 6:20pm
|
SQL Server is a much faster database then access and much more robust. However, issues I mention above can course it to run slower. ------------- 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: JJLatWebWiz
Date Posted: 16 January 2006 at 9:09pm
|
One thing that will slowdown the apparent SQL performance is the network connections between the Web server and the SQL server. With MS Access, everything takes place on the local machine and with no external network connections. With SQL, there is a good chance that the Web server is making dozens of network connections to the SQL server for each forum page.
You should compare the IP addresses of the Web Server to the SQL Server. They should at least be on the same subnet. For example, your web server is at IP: 213.202.100.41. If your SQL server is not 213.202.100.x, then the SQL is probably being shared by too many other web sites and the network connection between the servers is too slow. Your host may have multiple SQL servers and you could ask them to move you to a closer SQL server. ------------- p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users. |