| Author |
 Topic  |
|
|
stratacafe
Starting Member
Canada
44 Posts |
 Posted - 21 February 2009 : 19:50:50
|
The speed of posting has been terrible, so I took some time to transition the database from Access to MSSQL, thinking that would speed things up.
The speed jumped to a fraction of a second for new topics and replies, but is now back up at 16 seconds for no discernible reason.
I've made the changes to post.asp suggested on these forums, and even replaced my post.asp with the new version in 3.4.06, but it's still at 16 seconds.
Any ideas? Even replies of one word take 16 seconds to add to the database. This is on a dedicated server, and I have complete control over it, so any suggestions would be welcome.< |
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 21 February 2009 : 20:15:12
|
Do you have subscriptions enabled?
If true it could be taking some time to send out all the emails.< |
 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 21 February 2009 : 20:47:20
|
Make sure that file indexing is turned off.
If it's on a Windows based server,
- Go to start/run, type "services.msc" (no quotation marks) and hit enter.
- Scroll down to "Indexing Service", disable it, and stop it.
- If you have installed "Nero Burning ROM", it also installs an indexing program. Scroll down to "NMIndexingService", disable it, and stop it.
< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 February 2009 : 10:28:42
|
| Probably the migration tool you used didn't create the indexes a Snitz table requires, as the Access DB has very few, if any. So, it always goes down to the way you migrated your table. A SQL Server DB without indexes will perform just as bad or even worse than Access.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 22 February 2009 : 15:37:43
|
Yes, it does appear to be mail related. When subscriptions are disabled, the forum flies.
The server indexes and constraints are good.
Hrm. I'll have to think about that one. Speed vs. subs.< |
|
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 22 February 2009 : 15:42:16
|
| Oh, and thank you all for the suggestions!< |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 22 February 2009 : 19:30:19
|
The community isn't huge, but it is very active, so there's a lot of mail activity.
While the issue was mail related, it turns out I hadn't reset the mail server address. I still had it pointing at the old host. When I switched it to my new mail server, and turned subscriptions back on, everything flew.
That probably explains a rash of new "reverse IP" mail server errors I had been getting for the last day and a half as well.
This is my first time with complete control over the host machine, as we just moved from a shared environment. I'm just loving the speed boost and everything just feels more robust. Snitz feels new again.
I gotta give it to the community here. If they don't solve my problem, they are always offering suggestions about where to look for one, and most times that's exactly what I need =)< |
|
|
|
SiSL
Average Member
Turkey
671 Posts |
|
| |
Topic |
|
Topic Locked
<