| Author |
 Topic  |
|
|
prescottw
Junior Member
189 Posts |
 Posted - 15 September 2005 : 12:30:37
|
In a situation where an SHTML Page on a Linux server is accesing 8 databases 3 of which are SQL Server and 5 of which are MSAccess, would the page operate at peak if all db's were SQL Server?
I'm using syndication from 8 windows sites (all shared and possibly crowded), and I notice that the SHTML page boggs at the opening.
Not the CSS but only the body where the DB's request appears.
I'm thinking that 5 sites on a shared server with individual MSAccess DB's might prevent this page from opening quickly. I'm also thinking that it is still a page request as well as a DB Request.
Still Trying to put things together. Thank You. I hope I've worded the question correctly.
-prescottw |
What day is it anyway? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
prescottw
Junior Member
189 Posts |
Posted - 15 September 2005 : 13:11:49
|
I'm accessing 5 MSAccess db's from a MSwin2003 server as well as 3 SQL Server DB's using sydication mod.
User can view latest 10 topics from 8 seperate sites. From a linux site. User clicks and goes to that geographical site region.
Thank You,
-prescottw
|
What day is it anyway? |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
prescottw
Junior Member
189 Posts |
Posted - 15 September 2005 : 13:50:37
|
A JS on the Linux server is using syndicate.asp as the page requested. /topic.asp?Topic_ID=#### is the link produced by the script.
But yes the link appears on a Linux server.
Is the fulfillment rate based on site/page as well as DB return.
Question is are the DB's located on SQL Server returning the last ten topics faster than the access db's in the DB folders on the separate sites. Noticeably faster.
I appreciate your articulation of my questioning. You are helping me out a great deal. So what do you think. What is you expert opinion. Should I first go straight SQL Server on all sites. Will this take some of the strain off of being on shared servers.
Thank You,
-Scott
|
What day is it anyway? |
Edited by - prescottw on 15 September 2005 13:51:46 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 September 2005 : 14:29:30
|
Scott,
I guess you wrote that there were 800 sites at your server. That's the main problem, IMO. Of course, moving everything to SQL Server should help you get a faster response, but I just wonder how fast will it get...
You don't lose if you try it and then make a decision. With a less heavy loaded server things could go better. In the end, it's your call to decide if you'll want to pay the (heavy?) cost of running a dedicated server.
Just MHO. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
prescottw
Junior Member
189 Posts |
Posted - 15 September 2005 : 14:43:18
|
Thanks ruirib,
I see SQL Server necessary -even if- too. I can't lose, whether or not I'm on shared or dedicated or managed.
Thanks for you attentiveness.
-Scott |
What day is it anyway? |
Edited by - prescottw on 15 September 2005 15:11:43 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
