| Author |
Topic |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
 Posted - 2003-07-28 : 10:32:11
|
With the upgrade over the weekend, the forums are much, much faster. First, my apologies for not doing this sooner. I made quite a few modifications to the Snitz codebase and wasn't looking forward to making them all again. It turned out to be much easier than I thought.The biggest improvement is in the number of SQL statements sent to the server. I wrote an article on tuning the forums (http://www.sqlteam.com/item.asp?ItemID=6891) that highlights that. The forum homepage was sending 100+ SQL statements to the server. And the active topics page was much, much worse. For example, In the old Snitz code for the active topics page, a main query ran that returned all the topics. As additional informaton was needed, new queries were run. These queries ran once per row -- and there were a bunch of them. It seems as each new feature was added, they added a query rather than rewriting the original query. Something I know I've never done  Not only is this not very effecient from a SQL Server standpoint it also really brings network latency to the fore. Since the client (web server) is making 100-500 round trips to SQL Server per page, any little slowness in the network is magnified tremendously.In the new version of Snitz, it's all integrated into one honking big SELECT statement that is SQL Server, Access and MySQL friendly. There aren't any new indexes with the new code base. It's purely a matter of joining tables rather than selecting them separately.And if you like the look (and speed) of these forums you can download your own copy for free at www.snitz.com.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-29 : 15:39:45
|
| I am really liking the upgrade. It is so much faster, and I haven't encountered any errors. I also like the new look and feel.Thanks Graz!Tara |
 |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-07-31 : 02:22:30
|
| The 6th day after the updating. And today it worksextremely fast on my bad dial-up line...Thanks graz!!- Vit |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-07-31 : 03:33:36
|
old graz had a brilliant idea(while he sat on his stool from ikea)"I'll speed up the forum I bet that'll floor-em - might even be good for my career!"Thanks Graz - 1.37 gezillion times faster down under.... --I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-07-31 : 07:34:33
|
Why, these forums are faster !! - Jeff |
|
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2003-07-31 : 09:12:12
|
quote:
Originally posted by Stoadextremely fast on my bad dial-up line...
Get a faster connection Vit. ----------------Shadow to Light |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-07-31 : 14:24:34
|
| If you feel like experimenting with new features I like the quick reply :)======Doug G====== |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-31 : 14:35:35
|
quote:
Originally posted by Doug G
If you feel like experimenting with new features I like the quick reply :)======Doug G======
Ok I'll bite...Quick reply is when you have t3 installed?Brett8-)SELECT POST=NewId() |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-08-01 : 02:48:48
|
| Oh... no... I don't want 'SQL East Spammer' custom title...- Vit |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-08-02 : 18:15:23
|
| The quick reply is a configurable feature of this version that provides a reply window (without all the fancy editing buttons) on the same page as the thread you're reading, so you don't have to click reply and go to a new page to type a quick answer.======Doug G====== |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-08-04 : 08:59:31
|
| Yeah, but where is the quick reply located...I don't see it....Brett8-)SELECT POST=NewId() |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-08-04 : 09:21:22
|
| Hi Brett!! :)I'm with you, I don't see it too.- Vit |
|
|
|
|
Why these forums are faster