what a lousy job Chris Munder and his buddies have done with this thread management.
-
Chris Maunder wrote: Very similar to that, except that we have a 'position' field that requires sorting by a single column instead of the two columns that uses. As far as I understand this means you have to update many records, if someone posts to an older thread, doesn't it? IMHO the most difficult point is to find a balance between simple DB design and fast reading/writing. As I already told, I am currently designing my own forum, so please can you tell me the relation between
select's andinsert's/update's in the fora at CP? However, you do a great job w/ CP! Definitely. :) Regards Thomas Sonork id: 100.10453 Thömmi
Disclaimer:
Because of heavy processing requirements, we are currently using some of your unused brain capacity for backup processing. Please ignore any hallucinations, voices or unusual dreams you may experience. Please avoid concentration-intensive tasks until further notice. Thank you.Thomas Freudenberg wrote: As far as I understand this means you have to update many records, if someone posts to an older thread, doesn't it? No - it's only 1 record that is added regardless of where the message is entered. Thomas Freudenberg wrote: IMHO the most difficult point is to find a balance between simple DB design and fast reading/writing. As I already told, I am currently designing my own forum, so please can you tell me the relation between select's and insert's/update's in the fora at CP? The SELECT is a simple "SELECT * FROM Posts WHERE forum=n ORDER BY Position" Take a look at the version Uwe posted: The Code Project Discussion boards Thomas Freudenberg wrote: However, you do a great job w/ CP ta :) cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
-
When you have a clue, some suggestions on how to help alleviate the problem and a spell checker then I'll discuss the issue with you. FYI I did make some changes today that I hope will reduce the problem but until I get the time to rewrite the entire thing the best thing to do is write me a polite email and ask me to fix up whichever thread is playing up. It's called courtesy. cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
Chris Maunder wrote: When you have a clue, some suggestions on how to help alleviate the problem and a spell checker then I'll discuss the issue with you. Are al putdowns from Canberra this polite? :-D Chris Maunder wrote: ...but until I get the time to rewrite the entire thing... I thought this would be a quickie before breakfast kind of a thing for you. ;P Michael Martin Australia mjm68@tpg.com.au "In Summer, I like to dance naked on the roof to celebrate the event of the temperature finally falling below 40C (usually about midnight). But the neighbors have lately taken up the habit of staying up late. And looking up, at times, from their dreary, pointless lives..." - Roger Wright 15/05/2002
-
Thomas Freudenberg wrote: As far as I understand this means you have to update many records, if someone posts to an older thread, doesn't it? No - it's only 1 record that is added regardless of where the message is entered. Thomas Freudenberg wrote: IMHO the most difficult point is to find a balance between simple DB design and fast reading/writing. As I already told, I am currently designing my own forum, so please can you tell me the relation between select's and insert's/update's in the fora at CP? The SELECT is a simple "SELECT * FROM Posts WHERE forum=n ORDER BY Position" Take a look at the version Uwe posted: The Code Project Discussion boards Thomas Freudenberg wrote: However, you do a great job w/ CP ta :) cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
Chris Maunder wrote: Take a look at the version Uwe posted: The Code Project Discussion boards I see. So it is something like mentioned in the comments of the article I referenced in my previous post? Regards Thomas Sonork id: 100.10453 Thömmi
Disclaimer:
Because of heavy processing requirements, we are currently using some of your unused brain capacity for backup processing. Please ignore any hallucinations, voices or unusual dreams you may experience. Please avoid concentration-intensive tasks until further notice. Thank you. -
Chris Maunder wrote: Take a look at the version Uwe posted: The Code Project Discussion boards I see. So it is something like mentioned in the comments of the article I referenced in my previous post? Regards Thomas Sonork id: 100.10453 Thömmi
Disclaimer:
Because of heavy processing requirements, we are currently using some of your unused brain capacity for backup processing. Please ignore any hallucinations, voices or unusual dreams you may experience. Please avoid concentration-intensive tasks until further notice. Thank you.It's exactly that. cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
-
Thomas Freudenberg wrote: As far as I understand this means you have to update many records, if someone posts to an older thread, doesn't it? No - it's only 1 record that is added regardless of where the message is entered. Thomas Freudenberg wrote: IMHO the most difficult point is to find a balance between simple DB design and fast reading/writing. As I already told, I am currently designing my own forum, so please can you tell me the relation between select's and insert's/update's in the fora at CP? The SELECT is a simple "SELECT * FROM Posts WHERE forum=n ORDER BY Position" Take a look at the version Uwe posted: The Code Project Discussion boards Thomas Freudenberg wrote: However, you do a great job w/ CP ta :) cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
Chris Maunder wrote: "SELECT * FROM Posts WHERE forum=n ORDER BY Position" Chris, you're not really doing a "select *" are you? replace the * with the explicit column names, this will remove the need for sql to query column names on every execution now sql will optimize this if it is a stored procedure, but it will still check on each execute if the table's schema has changed,, explicitly naming columns is faster for both direct sql submission or stored procedures -John
-
When you have a clue, some suggestions on how to help alleviate the problem and a spell checker then I'll discuss the issue with you. FYI I did make some changes today that I hope will reduce the problem but until I get the time to rewrite the entire thing the best thing to do is write me a polite email and ask me to fix up whichever thread is playing up. It's called courtesy. cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
oh... don't give me that courtesy crap. You think u're doing anyone here a f*ckin favor? please... Your ads and microsoft sponsorship data is not renagading, but the forum isn't generating money, so let it stink. I think when there's a problem for this long, it needs to be pointed out, and there's no need to insult me for that.
-
When you have a clue, some suggestions on how to help alleviate the problem and a spell checker then I'll discuss the issue with you. FYI I did make some changes today that I hope will reduce the problem but until I get the time to rewrite the entire thing the best thing to do is write me a polite email and ask me to fix up whichever thread is playing up. It's called courtesy. cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
-
Could it be that chris and his buddies can't do effective tree management? I am trying hard not to think that is the case, but that's the only way my thoughts are lining. Too many threads renagading.
What a thoroughly venal comment! I suggest that you demonstrate the proper way to do this by establishing your own site and providing content of equal quality without any minor glitches. Alternatively, in case you're of a mind to actually contribute something of worth, you might submit an article that illustrates a truly foolproof algorithm for properly handling simultaneous posts. I Drowned Schroedinger's Stupid Cat!
-
When you have a clue, some suggestions on how to help alleviate the problem and a spell checker then I'll discuss the issue with you. FYI I did make some changes today that I hope will reduce the problem but until I get the time to rewrite the entire thing the best thing to do is write me a polite email and ask me to fix up whichever thread is playing up. It's called courtesy. cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
I think Edd needs a ban :~
-Domenic Denicola- [CPUA 0x1337] MadHamster Creations "I was born human. But this was an accident of fate - a condition merely of time and place. I believe it's something we have the power to change..."
-
oh... don't give me that courtesy crap. You think u're doing anyone here a f*ckin favor? please... Your ads and microsoft sponsorship data is not renagading, but the forum isn't generating money, so let it stink. I think when there's a problem for this long, it needs to be pointed out, and there's no need to insult me for that.
:eek: Geez, first your racist crap now this! Man, please vacate the forumn because you're sure making it a lot worse for the rest of us...
-Domenic Denicola- [CPUA 0x1337] MadHamster Creations "I was born human. But this was an accident of fate - a condition merely of time and place. I believe it's something we have the power to change..."
-
Could it be that chris and his buddies can't do effective tree management? I am trying hard not to think that is the case, but that's the only way my thoughts are lining. Too many threads renagading.
As you no doubt know being a software developer yourself, a large, complex codebase is difficult to make 100% bulletproof. Fortunately, even though this is a complicated technical matter, in your case there's a pretty straightforward fix to the problem that you can actually perform from the client side. Simply eliminate the text "www.CodeProject.com" from the address line of whatever browser you're using, and you'll find that the problem will be immediately resolved. Hope this helps, Chistopher Duncan Author - The Career Programmer: Guerilla Tactics for an Imperfect World (Apress)
-
Could it be that chris and his buddies can't do effective tree management? I am trying hard not to think that is the case, but that's the only way my thoughts are lining. Too many threads renagading.
I personally think that the only thing you're trying hard at is being an asshole. You've been a member less than a month and you think you know enough about what goes on here to offer an opinion? Your statement pegged the dipshit meter, obviating your lack of anything resembling what would be universally recognized as a "clue". Please step back, and take your own life so someone doesn't have to waste their own ammunition on you. :suss: "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 Please review the Legal Disclaimer in my bio.
-
When you have a clue, some suggestions on how to help alleviate the problem and a spell checker then I'll discuss the issue with you. FYI I did make some changes today that I hope will reduce the problem but until I get the time to rewrite the entire thing the best thing to do is write me a polite email and ask me to fix up whichever thread is playing up. It's called courtesy. cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
Chris, I think the best response to all of these people is to stop making excuses and fix the problem. You've said you were a) looking at it, b) thinking about it, and c) tweaking it for many weeks. So now you're getting some dings. Poor Chris! Stop whining and fix it.
-
Chris Maunder wrote: "SELECT * FROM Posts WHERE forum=n ORDER BY Position" Chris, you're not really doing a "select *" are you? replace the * with the explicit column names, this will remove the need for sql to query column names on every execution now sql will optimize this if it is a stored procedure, but it will still check on each execute if the table's schema has changed,, explicitly naming columns is faster for both direct sql submission or stored procedures -John
No, I'm not doing a select * ;) cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
-
Could it be that chris and his buddies can't do effective tree management? I am trying hard not to think that is the case, but that's the only way my thoughts are lining. Too many threads renagading.
-
While your response was short and to the point, I think mine was more descriptive and contained a certain amount of je ne sais quois. "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 Please review the Legal Disclaimer in my bio.
-
Well said, David:-) "Your village called -
They're missing their idiot." -
When you have a clue, some suggestions on how to help alleviate the problem and a spell checker then I'll discuss the issue with you. FYI I did make some changes today that I hope will reduce the problem but until I get the time to rewrite the entire thing the best thing to do is write me a polite email and ask me to fix up whichever thread is playing up. It's called courtesy. cheers, Chris Maunder Rub your belly and pat your head simultaneously. Sometimes that helps me make sense of things - Jon Sagara
Want some pest repellant Chris ? I'm sure a whipround would be successful :rolleyes: Elaine :rose: The tigress is here :-D
