| Author |
Topic |
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
 Posted - 2005-05-24 : 16:45:51
|
| my last post took 25 seconds according to the timer at the bottom of the page. Anyone else seeing a slowdown?-ec |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-24 : 17:21:17
|
I think it's just picking on you. Nah, had a few that were a little slow, but nothing consistent.---------------------------EmeraldCityDomains.com |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-05-25 : 15:27:09
|
| Testing...===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-05-25 : 15:29:04
|
| Testing...===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-05-25 : 15:40:26
|
| This is related to the number of subscriptions in this forum. An insert into a forum with no subscriptions is under one second. A little later tonight (i.e. when I'm less busy) I'll think through this a little more. The solution is most likely going to be disabling subscriptions at the forum level until I can find a better way to process these.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-05-25 : 18:12:02
|
| Graz, would cleaning up some of the really old subscriptions work?I know I'm subscribed to a bunch of things that I don't care to be subscribed to anymore.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-25 : 19:20:30
|
| With the volume of posts that come through, I'm surprised anyone subscribes to an entire forum. I can see subscribing to a single thread, but a whole forum?---------------------------EmeraldCityDomains.com |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-05-26 : 10:33:00
|
| I didn't get a chance to work on it last night. Michael, I think you're right on the first step. I'll probably clear out a bunch of older subscription topics. I think there are something like 20,000 total subscriptions. I also need to look at the Snitz code and make sure it's not pulling them all and checking on the client.I've also been considering some type of batch system to send them. I'll have to look into that too. There may be something already written for Snitz I can use.Mark, I don't allow forum level subscriptions to the really active forums (Developer, Administration, etc.). Only forums like Site News, Yak Corral, etc.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-05-26 : 11:27:58
|
| My posts are taking a very long time today. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-05-26 : 13:20:46
|
| And now it seems to be posting very quickly.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-05-26 : 13:21:17
|
| Or not. Hmmm.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
snitz is really slow
---------------------------