Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Slow SQL performance
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Slow SQL performance

 Post Reply Post Reply
Author
kiklop View Drop Down
Groupie
Groupie


Joined: 14 July 2005
Status: Offline
Points: 137
Post Options Post Options   Thanks (0) Thanks(0)   Quote kiklop Quote  Post ReplyReply Direct Link To This Post Topic: Slow SQL performance
    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
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: 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.
Back to Top
kiklop View Drop Down
Groupie
Groupie


Joined: 14 July 2005
Status: Offline
Points: 137
Post Options Post Options   Thanks (0) Thanks(0)   Quote kiklop Quote  Post ReplyReply Direct Link To This Post 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.
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: 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.
Back to Top
JJLatWebWiz View Drop Down
Groupie
Groupie
Avatar

Joined: 02 March 2005
Location: United States
Status: Offline
Points: 136
Post Options Post Options   Thanks (0) Thanks(0)   Quote JJLatWebWiz Quote  Post ReplyReply Direct Link To This Post 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.
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.