Web Wiz Support and Community Forums : Slow SQL performance https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 18:06:31 +0000 Mon, 16 Jan 2006 21:09:21 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17986 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Slow SQL performance : One thing that will slowdown the...]]> https://forums.webwiz.net/slow-sql-performance_topic17986_post97491.html#97491 Author: JJLatWebWiz
Subject: 17986
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.
]]> Mon, 16 Jan 2006 21:09:21 +0000 https://forums.webwiz.net/slow-sql-performance_topic17986_post97491.html#97491 <![CDATA[Slow SQL performance : SQL Server is a much faster database...]]> https://forums.webwiz.net/slow-sql-performance_topic17986_post97480.html#97480 Author: WebWiz-Bruce
Subject: 17986
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.
]]> Mon, 16 Jan 2006 18:20:30 +0000 https://forums.webwiz.net/slow-sql-performance_topic17986_post97480.html#97480 <![CDATA[Slow SQL performance : -boRg- wrote:but as you have...]]> https://forums.webwiz.net/slow-sql-performance_topic17986_post97478.html#97478 Author: kiklop
Subject: 17986
Posted: 16 January 2006 at 5:44pm

Originally posted by -boRg- -boRg- wrote:

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.


Ah, i have forget to enable this (now enabled for both forums and the difference is evident)

Originally posted by -boRg- -boRg- wrote:

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.


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.]]> Mon, 16 Jan 2006 17:44:43 +0000 https://forums.webwiz.net/slow-sql-performance_topic17986_post97478.html#97478 <![CDATA[Slow SQL performance : Seemed to load in about the same...]]> https://forums.webwiz.net/slow-sql-performance_topic17986_post97475.html#97475 Author: WebWiz-Bruce
Subject: 17986
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.
]]> Mon, 16 Jan 2006 17:20:51 +0000 https://forums.webwiz.net/slow-sql-performance_topic17986_post97475.html#97475 <![CDATA[Slow SQL performance : I decided to finally convert my...]]> https://forums.webwiz.net/slow-sql-performance_topic17986_post97427.html#97427 Author: kiklop
Subject: 17986
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]]> Mon, 16 Jan 2006 13:10:18 +0000 https://forums.webwiz.net/slow-sql-performance_topic17986_post97427.html#97427