| Author |
 Topic  |
|
mafifi
Junior Member
USA
308 Posts |
 Posted - 24 February 2009 : 22:05:13
|
| I installed Snitz forums on my web site about a year ago. About a week ago some of the users noticed some performance issue when inserting records in the database. When I tested I found that it takes about 45 seconds to reply to or post a new topic. I did not see any performance issues when I edit one of my previous posts. My database is on a separate server from the application server where Snitz is installed. I checked the application server performance and error logs and did not see any anomalies. I logged on the application server and browsed to the site and with the same performance issues. The database (SQL 2000) is fine, as I had a DBA look at it and did not see anything out of place. I also tried Fiddler and it shows that the application stalls at 'post_info.asp' file. I built a new database and used fresh data (I did not use the legacy data), then re-installed Snitz in a different directory and the test is flying. Less than .02 seconds to generate the page. I am working on this issue since 7:30 AM and it is almost 10:00 PM now, so any help or ideas will be greatly appreciate it.< |
Regards,
Mo |
Edited by - mafifi on 25 February 2009 08:51:46 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 25 February 2009 : 01:41:44
|
| do you have subscriptions enabled ?< |
 |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 25 February 2009 : 06:45:22
|
quote:
Originally posted by HuwR
do you have subscriptions enabled ?
Yes, "Subscribe to Whole Board".< |
Regards,
Mo |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 25 February 2009 : 06:52:21
|
| then that is what is causing your problem, everytime someone posts it will be sending an email to everyone who is subscribed.< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 25 February 2009 : 09:15:32
|
| Just as an FYI, when you go back and edit the original post its hard for someone to follow what's going on and provide appropriate help.< |
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 25 February 2009 : 09:23:32
|
quote:
Originally posted by AnonJr
Just as an FYI, when you go back and edit the original post its hard for someone to follow what's going on and provide appropriate help.
I just corrected a spelling error. Sorry.< |
Regards,
Mo |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 25 February 2009 : 11:20:43
|
quote:
Originally posted by Podge
Which email component are you using ?
ASPEMail< |
Regards,
Mo |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 25 February 2009 : 12:51:52
|
| if you have the paid version rather than the free version then you should be able to use the queueing functions of aspemail which should aleviate most of the problem< |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 25 February 2009 : 18:17:06
|
| Thanks for the feedback. I will start by the paid version of ASPEmail sometime this weekend or early next week. I will keep you in the loop.< |
Regards,
Mo |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 27 February 2009 : 17:50:04
|
quote:
Originally posted by HuwR
then that is what is causing your problem, everytime someone posts it will be sending an email to everyone who is subscribed.
Therefore, if I change the setting to [Topic] or [Forum] then all new users will be restricted to these new settings, correct. What happened to existing users, Will they remain board-wide subscribers until they make the changes or the administrator makes the changes on their behalf?< |
Regards,
Mo |
Edited by - mafifi on 27 February 2009 17:50:47 |
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 01 March 2009 : 12:16:52
|
quote:
Originally posted by Podge
Try CDOSYS first if its available. It should be if you're in Windows 2003+<
I have tried CDOSYS this morning and I did not see any improvements (45 seconds). I will try the paid version of ASPEmail sometime tomorrow. |
Regards,
Mo |
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 01 March 2009 : 12:55:47
|
According to ASPEmail documentation (http://www.aspemail.com/manual_07.html), I will have to enter the following:
objNewMail.Queue = True
before
objNewMail.Send
in file 'inc_mail.asp'. Right? |
Regards,
Mo |
Edited by - mafifi on 01 March 2009 13:01:39 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Topic |
|
Topic Locked
