|
I'll add this to the TODO, but surprisingly this isn't straight forward.
To do this you need to know whether a message has children and that can be done in three ways: we calculate on the fly, or we join with a table that has the number of messages in each thread, or we store the number of children in the row for each message itself (a denormalised value). The first method is slowest, the last method the fastest, the middle method is the neatest (to me), but still too slow.
A further issue is that we'd probably need to add this new denormalised column to the main index, and would also need to update this denormalised column each time a message is added/deleted. This slows down message posting.
None of this is a huge issue, and the extra load is a small, most likely unnoticeable incremental slowdown, but with a system as finely tuned as the forums I'll need to set aside a good solid chunk of time to test and experiment.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
do you actually need to store hte number of children? I'd htink you'd only need to do a children exist count when the message is deleted to see if it can be made to disappear completely. If so, could you instead just add a bool column to the message table that is true for messages that are deleted and which should be hidden, and then do the children exist check in the background when a message is deleted and update the column after the check.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
Dan Neely wrote: I'd htink you'd only need to do a children exist count when the message is deleted to see if it can be made to disappear completely
You're right: we don't need to store the actual child count, and I'll admit I was thinking about a few other features I would like to add that do require the child count. However, a flag "IncludeInListings" vs a child count boils down to the same thing.
Regardless: I've added it to the TODO list.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
|
Have you been through the Who's Who and search memberid for 'loans'
They are still active despite the post below this morning, 6 pages worth......
|
|
|
|
|
That lot went quickly.
I believe the loans should be called Pink Pounds 
Panic, Chaos, Destruction. My work here is done.
Drink. Get drunk. Fall over - P O'H
OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer
Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
|
|
|
|
|
Pink loans can be found here[^], I drive past them every morning. Tomorrow I shall be getting even closer.
Every man can tell how many goats or sheep he possesses, but not how many friends.
|
|
|
|
|
Found him[^] here[^]
thatraja
My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
All these are my opinions. Different people. different way of thinking. I am no one to judge others - Chandru
|
|
|
|
|
obliterated
Vince
Remember the dead, fight for the living
|
|
|
|
|
This[^] article in todays insider was originally sent on march 22[^]. 
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
Wow. You scare me.
However, I'm going to pass this on to Terry. Should I point and laugh, or use my serious face?
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
The former.
It was memorable mostly because I was being threatened with an html5 project at the time and despise K&R style.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
I find the storm into the office, point and say in a really convincing angry tone, 'You!'.........wait for the look of panic to show, then start laughing.
They tend to $h!t themselves more. 
|
|
|
|
|
Not sure about this one but looks like one:
http://www.codeproject.com/script/Membership/View.aspx?mid=5187843[^]
Reason for doubt: he seems to only post messages in respond to articles / questions that actually have something to do with the products on the site. But they aren't free so and he is the CEO of the company offering the products (see here[^] ) so...
|
|
|
|
|
I'd say no. He's linking [a lot] to his company's web site but has been active on CP.
Panic, Chaos, Destruction. My work here is done.
Drink. Get drunk. Fall over - P O'H
OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer
Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
|
|
|
|
|
All of his messages[^](except fist message) contain the same advertisement things message
thatraja
My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
All these are my opinions. Different people. different way of thinking. I am no one to judge others - Chandru
|
|
|
|
|
Currently when a comment is added for example to a question, it's sended to the person who created the question. If somebody (including the author of the question) would want to send a comment to the editor of the question, there's no direct mechanism for that.
Would it make sense to add such capability?
|
|
|
|
|
Yes there is.
Click on the users name and email directly.
Not very elegant, but it is there.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
Yep, I know, but that's kinda around the corner 
|
|
|
|
|
I don't think so because most who edit a question are doing so to improve readability, not because they may be an expert in the field. Having notifications sent purely because you cleaned up someone's mess is a disincentive I would think.
[Edit: I was initially thinking about your request as a "every comment posted to a question gets sent to all editors" but I see you're thinking purely on a "how do I contact an editor directly" type thing. Still not sure it's worth it, but would like to hear your thoughts]
What scenario are you thinking about?
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
modified on Friday, August 12, 2011 10:47 AM
|
|
|
|
|
Thanks for the reply, yes you're right I'm thinking an optional mechanism where basically anyone could send a message to the editor.
One scenario is when a modification is rolled back. As you said, editing is normally done to enhance readability so if it's rolled back the author could add an explanation why.
Perhaps another usage could be when sequential edits are made. The latter editor could add a comment what else has been done for the post. If it's the first edit this info would be sent to the author.
I think the 'big' thing would be to learn how good edits are made and to the authors, what were the initial problems with the post. Also if the author just wants to comment something about the editing, that would be possible.
Now when I'm thinking this a bit more, it sounds more like an 'editor notes' system which would be a parallel chain of comments to the actual question and it's comments.
Makes any sense? 
|
|
|
|
|
I think "editor notes" is the key here.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
Did you know about this?
Smilie Construction kit[^]
I want this: > : )
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"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
|
|
|
|
|
Cool list.
I want the CP image(which already made) as a smiley
:new: ---> new[^]
If possible please bring the star(Which appears on high rated messages in forums) too
:star:
thatraja
My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
All these are my opinions. Different people. different way of thinking. I am no one to judge others - Chandru
|
|
|
|
|
I do my smilies in MSPaint
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
