| Author |
 Topic  |
|
MarioLanning
New Member
USA
50 Posts |
 Posted - 28 May 2002 : 00:46:32
|
I have searched the SQL forum and tried all the patches like the SQL database connect string, the member count fix only to have a very slow load of my default page. I have even upgraded to the latest version an applyed the database upgrade. I'm at a loss as to why its so slow.
http://support.myserver.org is the address to my forum.
Please advise.
Mario |
|
|
Rasco
Advanced Member
Germany
3192 Posts |
Posted - 28 May 2002 : 03:27:56
|
Sorry, your forum loads very fast for me.
Maybe, it`s your connection or have other users of it the same problem?
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 28 May 2002 : 06:37:04
|
| It loads very slowly for me - also compared to this forum and my own forum, so something is definately wrong. Have you modified the default.asp in any way ? |
|
|
|
MarioLanning
New Member
USA
50 Posts |
Posted - 28 May 2002 : 09:57:48
|
Nope, the default page is stock 3.3.05 material. Only made the change for the member count fix.
I went into the inc_footer and removed the timer lines. 24533.48 shows up on the page now.
http://widescreenhd.tv
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 May 2002 : 13:28:48
|
The value you are getting now is absurd. You forgot to uncomment this line at the top of inc_top.asp:
Open inc_top.asp and uncomment line 58:
' StartTimer 1
The link I previous posted mentioned that this was also needed. So, remove the comment from that line to have a meaningful value being shown for the page generation time.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
grazman
Junior Member
USA
193 Posts |
|
|
MarioLanning
New Member
USA
50 Posts |
Posted - 28 May 2002 : 21:41:51
|
Ok, I undid the comment for the timer in the inc_top, it took it to 4.296875
Let me fiddle with the other script now
Mario
P.S. THank you for helping me out here.
http://widescreenhd.tv
|
|
|
|
MarioLanning
New Member
USA
50 Posts |
Posted - 28 May 2002 : 21:54:44
|
I tried the scrip in my query anyliser selecting the database tha the forum is using but I only get a message
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'FORUM_CATEGORY'.
I saw this area of your one post
"In another thread I promised a script to test the performance of SQL Server. This script simulates the load that default.asp places on a SQL Server. It should be independant of what is actually in your database. It does use FORUM_ as the prefix. A simple search and replace should fix that if needed."
What would I change the FORUM_ to with a search and replace?
http://widescreenhd.tv
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 May 2002 : 22:03:57
|
quote:
Ok, I undid the comment for the timer in the inc_top, it took it to 4.296875
Let me fiddle with the other script now
Mario
P.S. THank you for helping me out here.
I got a similar value. For a small forum like you currently have it's a bit slow, although not as much as I expected after reading your first post.
Are you using the OLEDB driver (I think you are, but just making sure). Are you hosting this yourself? If so, you could try to download the latest MDAC from Microsoft and see if that helped...
Reagarding the replacement of FORUM_ have a look at your config.asp and verify the value of strTablePrefix (it's defined just below the strConnString definition. That's the value you should use in your search and replace.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
MarioLanning
New Member
USA
50 Posts |
Posted - 28 May 2002 : 22:52:37
|
this is the string I'm using for the config.asp. I of course removed the password ;-)
strConnString = "Provider=SQLOLEDB;Data Source=webfarm;database=snitz;uid=username;pwd=password;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
As far as the search and replace I'm still lost.
Here is what my config.asp has
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
http://widescreenhd.tv
|
|
|
|
MarioLanning
New Member
USA
50 Posts |
Posted - 28 May 2002 : 22:55:42
|
I'm wondering if I need to upgrade the SQL server, its only a PIII 1.0 Ghz with 512 MB ram, Its doing about 20 million queries a day because we have over 15,000 Domains querying off it. alot of the domains are high profile companys.
I'm thinking it's going to have to be replaced.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 May 2002 : 04:33:53
|
quote:
this is the string I'm using for the config.asp. I of course removed the password ;-)
strConnString = "Provider=SQLOLEDB;Data Source=webfarm;database=snitz;uid=username;pwd=password;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
As far as the search and replace I'm still lost.
Here is what my config.asp has
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
This is the best driver available and that's the usual table prefix. I don't understand why the table FORUM_CATEGORY cannot be found...
Well maybe the fact that you have a heavy loaded SQL Server can explain why he takes 4.0 secs for default.asp to load. The current default.asp is a bit heavy in terms of the number of queries to the server. Things will improve with 3.4, that must be coming out soon...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 May 2002 : 18:22:06
|
quote:
I tried the scrip in my query anyliser selecting the database tha the forum is using but I only get a message
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'FORUM_CATEGORY'.
I saw this area of your one post
"In another thread I promised a script to test the performance of SQL Server. This script simulates the load that default.asp places on a SQL Server. It should be independant of what is actually in your database. It does use FORUM_ as the prefix. A simple search and replace should fix that if needed."
What would I change the FORUM_ to with a search and replace?
http://widescreenhd.tv
Did you log into query analyser as the same user as your forum was created by ? if not then you should brefix the table names with the dbowners name
ie
myforumlogin.FORUM_CATEGORY
|
|
|
|
MarioLanning
New Member
USA
50 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 30 May 2002 : 07:13:25
|
quote:
Whats all he lines about effected mean?
That's just the number of records returned by each SQL statement.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Topic |
|
Topic Locked
