Bugs and Suggestions

15-Apr-10 2:14

Why does loading the lounge directly via www.codeproject.com/lounge take forever while going vai the main page and click on the first lounge message loads instantly?

Wout Louwers

Corporal Agarn15-Apr-10 3:43

Corporal Agarn

15-Apr-10 3:43

I have not noticed this. Seems about the same to me.

Chris Maunder15-Apr-10 5:57

15-Apr-10 5:57

Is it a particular server? (look at the very bottom of the page under the bottom banner - you'll see the server name)

cheers,
Chris Maunder

The Code Project | Co-founder
Microsoft C++ MVP

WoutL15-Apr-10 21:43

15-Apr-10 21:43

No, it is not the server.

But when I go to the lounge and hit 'refresh' the loading of the page takes a lot of time. Sometimes even longr then 30 seconds. And after 30 seconds you get a 'busy server' message.

But when I use a permalink and hit refresh, the page loads within 5 seconds.

Wout Louwers

WoutL19-Apr-10 23:29

19-Apr-10 23:29

Chris,

Ii am not the only one who notices this behaviour: Message from th Lounge[^]. Could it have to do with "SQL parameter sniffing"?

Wout Louwers

Chris Maunder20-Apr-10 3:37

20-Apr-10 3:37

We're still trying to find out why the sudden load and unfortunately nothing obvious is sticking it's head up.

We're not ignoring - just digging deeply.

cheers,
Chris Maunder

The Code Project | Co-founder
Microsoft C++ MVP

WoutL20-Apr-10 11:11

20-Apr-10 11:11

Chris,

Although I do not know how the site works, I can imagine that the messages for the lounge are loaded by a single stored procedure. And that the same stored procedure is used for loading the lounge main page or loading a permalink to a message in the lounge. If this is how it works, the procedure will have parameters that sometimes have values and sometime are NULL. If this is the case, the stored procedure would need different execution plans for different situations, and that is one thing where MSSQL is not at his best. If you have a test system (with a similar amount of messages) you could test this as follows:

Run the stored procedure with different situations and look at the execution plan.
Change the sp. The only thing you have to change is saving it with "with recompile"
Run the previous situations again and compare the outcomes.

If there are differences you have two options: Add the 'with recompile' to the production systems, or split the single sp in two or more variants so they can have there own execution plans.
As mentioned before: I don’t know how your site works. I am only a member who is trying to help.

Wout Louwers

Chris Maunder20-Apr-10 11:23

20-Apr-10 11:23

I'll pass these suggestions on.

We tend to tune specifically for the core scenarios and typically the exectution plan is sensible (well, sensible after we've wrestled it into submission with index hints). SQL Server is terrible at making guesses sometimes.

cheers,
Chris Maunder

The Code Project | Co-founder
Microsoft C++ MVP

WoutL20-Apr-10 11:32

20-Apr-10 11:32

Chris Maunder wrote:
SQL Server is terrible at making guesses sometimes.

O yes, I know. Thats why you have to split the sp's sometimes. The main sp can still exist, so you doe not have to change other code, but if you let that sp call different sp's, you help SQL to choose its indexes. It is sometimes more simple than working with idex hints.

Wout Louwers

Chris Maunder20-Apr-10 14:45

20-Apr-10 14:45

We think we've solved the proble,. The trick: removing an index. SQL Server can suffer a problem whereby it doesn't have time to evaluate the indexes properly so chooses the wrong one.

cheers,
Chris Maunder

The Code Project | Co-founder
Microsoft C++ MVP

WoutL20-Apr-10 19:51

And these guys need to be deleted

20-Apr-10 19:51

Never knew a select query could benefit from removing an index. So I allready learned somthing new today. And my workday has just started!

Wout Louwers

#realJSOP15-Apr-10 0:00

#realJSOP

15-Apr-10 0:00

He's spamming Q/A.

http://www.codeproject.com/script/Membership/View.aspx?mid=7108498[^]

http://www.codeproject.com/script/Membership/View.aspx?mid=7093743[^]

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Re: And these guys need to be deleted

Luc Pattyn15-Apr-10 0:33

Luc Pattyn

15-Apr-10 0:33

You could try a Who's Who filter of cheap* and be surprised at the outcome.
These guys know their HTML.
Not sure it is safe!

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

Re: And these guys need to be deleted

Sean Ewington15-Apr-10 3:11

Sean Ewington

15-Apr-10 3:11

Good gravey!

Thanks,
Sean Ewington
The Code Project

Web17 seems to be having some problems.

Pete O'Hanlon14-Apr-10 23:26

Pete O'Hanlon

14-Apr-10 23:26

I've just tried to delete a reply from the spammer below, and got the following response:

"Error: Exception of type 'System.OutOfMemoryException' was thrown.. Ticket: 2227260. Server: Web17"

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Web17 seems to be having some problems.

Chris Maunder15-Apr-10 0:54

Re: Web17 seems to be having some problems.

15-Apr-10 0:54

Hmm - interesting.

Web17 has always been a trouble maker and I actually pulled it out of the cluster last night on my way to decommissioning it completely.

Someone left the door open and he snuck back in. Hmmm | :|

cheers,
Chris Maunder

The Code Project | Co-founder
Microsoft C++ MVP

Luc Pattyn15-Apr-10 6:25

Luc Pattyn

15-Apr-10 6:25

servers normally want to get out, not in. You shouldn't trust that one any longer! Please revoke all of its privileges.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

Needs Deletion

Dalek Dave14-Apr-10 22:28

Dalek Dave

14-Apr-10 22:28

This Member[^]

Only posted to spam on Q&A

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

Tom Deketelaere14-Apr-10 23:06

Tom Deketelaere

14-Apr-10 23:06

He is actually doing it with 2 accounts

This is the same member[^]

Estys14-Apr-10 23:30

Estys

14-Apr-10 23:30

there are more :

cialis 20 mg

diflucan medication

Ankur^\m/14-Apr-10 23:50

Ankur^\m/

14-Apr-10 23:50

And many more:
Check this post[^] Mad | :mad:

Currently I am editing their answers to remove the messages.

..Go Green..

Dalek Dave14-Apr-10 23:52

Dalek Dave

14-Apr-10 23:52

Racking up those edit points! Smile | :)

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

Ankur^\m/15-Apr-10 0:14

Ankur^\m/

15-Apr-10 0:14

..Go Green..