| Author |
 Topic  |
|
|
Pikachoad
Starting Member
12 Posts |
 Posted - 26 February 2001 : 17:31:10
|
I just changed our forums over from Access to SQL 7. After the transition, default.asp runs REAL slow, but any other page loads as fast as it should. Any ideas what could cause this? There is another set of snitz forums running on the same SQL server (different site) so I know the server is fine...
Thanks!
Matt
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 27 February 2001 : 02:08:12
|
This site runs on SQL 7, it the default.asp here slower for you then other pages ?
Pierre |
 |
|
|
Pikachoad
Starting Member
12 Posts |
Posted - 27 February 2001 : 08:13:57
|
Yes- the default.asp is the slow page- out of the whole site, and out of the rest of the forums. Forums.asp and topic.asp both load VERY fast.
Last night I did some testing, and I can rule out any of the includes and subs in default.asp. It is something to do with when it is figuring up the numbers of topics or posts. Because I also found that when I do an Update Forum Count from the admin section, it also goes real slow. So default.asp and the Update Forum Count both go REAL slow.
So maybe an error in the importing of either the reply or topic table???
Thanks so much for your help.
My site is airsoft.polyactive.net if you would like to see what I mean. Just give the default page a few seconds, then access any topic, and you will see the speed difference.
Matt
quote:
This site runs on SQL 7, it the default.asp here slower for you then other pages ?
Pierre
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 27 February 2001 : 08:53:23
|
This is because the page consiste of two nested query loops ne for categories one for forums which are iterated to generate the page the other pages do not do this, since they are related to a specific forum or topic, and do not need to iterated through th category/forum tree.
Obviously the count update is doing a similar process to count all the replies and topics.
So the more categories and forums you have the slower default.asp will become.
|
|
|
|
steverrific
Starting Member
USA
16 Posts |
Posted - 27 February 2001 : 09:48:21
|
Maybe I can help.
I've setup a couple of SQL based Snitz forums and the issue that plauged me was my connection to the SQL database. If you have access to the server, it's best to create a DSN to the database. Essentially, this creates a permanent connection to you database so your forum doesn't have to authenticate everytime you have a request.
To do this, go into ODBC, under system DSN click add and put in the information to connect to your database. It should be pretty straight forward. Choose all of the default except to make your forum database your default database (I think it usually makes "master" your default).
Then you have to go and re-setup the connection to you database in your config.asp and run the setup again. In the connection string, just put dsn=yourdsnname.
This might or might not help. If you need more detail, please let me know.
Edited by - steverrific on 27 February 2001 09:50:13 |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 27 February 2001 : 10:11:13
|
I'm sorry but I am going to have to disagree with you on that.
There have been many articles and discussions on DSN vs DSN less connections, and it is generally considered better for performance to use a DSN less connection like we do in the forum.
when you use a connection like this
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;
you are accessing the OLEDB layer directly, using a DSN connection, first the machine looks in the registry to find out what the DSN is, it then talks to the OLEDB layer using ODBC, not directly.
While this may not be a noticable difference on sites with only a few hundred hits a day, when you are getting thousands, the performance improvements are significant.
|
|
|
|
Pikachoad
Starting Member
12 Posts |
Posted - 27 February 2001 : 10:24:33
|
Okay, this morning I created a second forum site, and starting just renaming tables in SQL... the categories went over fine, as did the members. It still loaded fast. But when I moved over the FORUM_FORUM table, THAT is when it slowed drastically.
HuwR- did you check out the site yet?
http://airsoft.polyactive.net/forums/default.asp
I dont have nearly as many forums/categories as your site here... so I dont think I have too many forums (yet).
Also, my Access 2000 FORUM_FORUM table did NOT have the F_USERLIST field in it, so I had to add that before importing the data.
Thanks again,
Matt
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 27 February 2001 : 10:30:42
|
the latest versions of the forum do not use F_USERLIST, they use a table called ALLOWED_MEMBERS.
|
|
|
|
steverrific
Starting Member
USA
16 Posts |
Posted - 27 February 2001 : 10:36:34
|
Thanks for the info, HuwR(and the correction).
I had 15 seconds delays with each page load that were resolved when I created the DSN entry, but evidently that's not the case other forums.
*I will shut up now.  *
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 27 February 2001 : 10:39:31
|
Ok, I have now looked, this is a copy of your site I take it, and not the live one.
This is definately not normal behavior, your default .asp takes a very long time to load, evn longer than ours here.
Have you modified any of your files ?
If you are able , add an index to the category table on the cat_name field, and to the FORUM table, add 2 indexes, one for CAT_ID and the other for F_SUBJECT, this should help the querries perform quicker
|
|
|
|
Pikachoad
Starting Member
12 Posts |
Posted - 27 February 2001 : 11:55:37
|
No, I have not modded any files at all.
I added the indexes, no change.
Since the forums were only around for a month, I think I will just start them over from scratch... hehe.
Thanks for all of your help.
Matt Kuss
|
|
|
|
Pikachoad
Starting Member
12 Posts |
Posted - 27 February 2001 : 13:24:43
|
HuwR- I made a blank install of the forums- in the copy, the _FORUM table has the first two fields, CAT_ID and FORUM_ID with keys next to them, but in my working copy, only the FORUM_ID has one, not the CAT_ID.
Could THAT be causing slower querying????
Thanks.
Matt Kuss
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 27 February 2001 : 13:56:13
|
it may do, it would be fairly is to add an see
|
|
|
| |
Topic |
|
Topic Locked
