Comments in Articles
-
I didn't like the change at first but I think the speed increase on loading articles will be worth it. I guess it come to how often people look at the comments vs how often do they just want to download the code. Michael Fat bottomed girls You make the rockin' world go round -- Queen
I don't like it either. To stisfy both sides, IMO this would be a nice option for the personal preferences ? Default is off, but those who like it can switch it on. Just my 2c -Chris
-
I didn't like the change at first but I think the speed increase on loading articles will be worth it. I guess it come to how often people look at the comments vs how often do they just want to download the code. Michael Fat bottomed girls You make the rockin' world go round -- Queen
Michael P Butler wrote: I didn't like the change at first but I think the speed increase on loading articles will be worth it. I miss that too :(( I use 33.6kbps dial-up connection at home, and it was easier to open the articles in separate IE windows, disconnect (every second costs money here) and then read the articles along with the comments. But anyway, it seems I'll have to get used to it :| Rado
-
I think Chris is alleviating the CPU and database load... I didn't like it too. I see dumb people
-
I think that it is an excellent way to save bandwidth. It might be nice to have an extra comment that indicates if there are any messages that are new in the comments, but otherwise I like it!
Build a man a fire, and he will be warm for a day
Light a man on fire, and he will be warm for the rest of his life! -
I too really hate it, but if it saves bandwidth and makes CP a faster place, who am I to complain in the end? I would strongly like an option in my personal settings that lets me turn *on* all article discussion boards by default, rather than having to go through a seperate page-load-click-load procedure, if that's possible, as I have yet to read an article without wanting to read any comments posted under it at the same time and that extra twenty seconds as the forum page loads has gotten annoying very quickly, almost like my sentances that have no periods in them. Could it happen?
David Wulff http://www.davidwulff.co.uk
David Wulff Born and Bred.
-
I don't like it either. To stisfy both sides, IMO this would be a nice option for the personal preferences ? Default is off, but those who like it can switch it on. Just my 2c -Chris
But a personal preference wouldn't help with the server/database load problem. Michael Fat bottomed girls You make the rockin' world go round -- Queen
-
I too really hate it, but if it saves bandwidth and makes CP a faster place, who am I to complain in the end? I would strongly like an option in my personal settings that lets me turn *on* all article discussion boards by default, rather than having to go through a seperate page-load-click-load procedure, if that's possible, as I have yet to read an article without wanting to read any comments posted under it at the same time and that extra twenty seconds as the forum page loads has gotten annoying very quickly, almost like my sentances that have no periods in them. Could it happen?
David Wulff http://www.davidwulff.co.uk
David Wulff Born and Bred.
as I have yet to read an article without wanting to read any comments posted under it at the same time Yes, in fact I often read the comments first to see if the rest of the article is worthwhile! I find this change annoying. I wonder how much it improves bandwidth though. an option in my personal settings that lets me turn *on* all article discussion boards Yes! Marc Help! I'm an AI running around in someone's f*cked up universe simulator.
sensitivity and ethnic diversity means celebrating difference, not hiding from it. - Christian Graus -
what is this change you guys are talking about? My article on a reference-counted smart pointer that supports polymorphic objects and raw pointers
-
This change was discussed in the Suggestions forum but after sleeping on it I've decided to pull it. It was speeding up page loads by about 30% but I'm sure we can find other means to improve performance without sacrificing usability. Thanks for the comments guys - I appreciate the feedback. cheers, Chris Maunder
-
what is this change you guys are talking about? My article on a reference-counted smart pointer that supports polymorphic objects and raw pointers
Just click on your signature and go to the comments section. :-D
I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past. -Chris Maunder Microsoft has reinvented the wheel, this time they made it round. -Peterchen on VS.NET
-
Uwe Keim wrote: Free Windows-based Web Content Management System How is the CMS product fairing? Found a partner, still looking, doing it yourself?
Paul Watson
Bluegrass
Cape Town, South AfricaChristopher Duncan wrote: Which explains why when Santa asked, "And what do you want for Christmas, little boy?" I said, "A life." (Accesories sold separately)
Oh, thanks for asking. Currently we found no partner and doing it for ourself so far. You know, to find a TRUSTWORTHY partner is really really difficulty. Is YOUR company interested? -- - Free Windows-based Web Content Management System: http://www.zeta-software.de/enu/producer/freeware/download.html - Scanned MSDN Mag ad with YOUR name: www.magerquark.de/misc/CodeProject.html - See me: www.magerquark.de
-
Just click on your signature and go to the comments section. :-D
I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past. -Chris Maunder Microsoft has reinvented the wheel, this time they made it round. -Peterchen on VS.NET
I see all the comments directly as I used to. Has that something to do with me being a "supporter" My article on a reference-counted smart pointer that supports polymorphic objects and raw pointers
-
This change was discussed in the Suggestions forum but after sleeping on it I've decided to pull it. It was speeding up page loads by about 30% but I'm sure we can find other means to improve performance without sacrificing usability. Thanks for the comments guys - I appreciate the feedback. cheers, Chris Maunder
Chris Maunder wrote: but I'm sure we can find other means to improve performance without sacrificing usability. Yes, we can, I have a suggestion: Using XML on the server and some smart scripting on the client, in the Dynamic view, you can pull ONLY the headers to form the forum tree. Then, when you click on a message, the script downloads only that message from the server. This will reduce a lot the bandwidth. Most people don't read all the messages on the page, but they DO want to see all the headers. You could even come with a 100~150 messages per page with this scheme, to speed up things even more. I see dumb people
-
Chris Maunder wrote: but I'm sure we can find other means to improve performance without sacrificing usability. Yes, we can, I have a suggestion: Using XML on the server and some smart scripting on the client, in the Dynamic view, you can pull ONLY the headers to form the forum tree. Then, when you click on a message, the script downloads only that message from the server. This will reduce a lot the bandwidth. Most people don't read all the messages on the page, but they DO want to see all the headers. You could even come with a 100~150 messages per page with this scheme, to speed up things even more. I see dumb people
-
Chris Maunder wrote: but I'm sure we can find other means to improve performance without sacrificing usability. Yes, we can, I have a suggestion: Using XML on the server and some smart scripting on the client, in the Dynamic view, you can pull ONLY the headers to form the forum tree. Then, when you click on a message, the script downloads only that message from the server. This will reduce a lot the bandwidth. Most people don't read all the messages on the page, but they DO want to see all the headers. You could even come with a 100~150 messages per page with this scheme, to speed up things even more. I see dumb people
The issue isn't the amount of data returned between the SQL and WebServer (though this is important), but rather the work done in scanning tables and indexes (indices?) and sorting the messages to return the messages in the correct threaded order for the specified forum with the specified constraints. Once the messages to be displayed has been determined then actually returning that info is trivial. Forcing the client to implement some kind of XSLT to convert the XML to HTML would mean some browsers simply wouldn't be able to view the information. The solution is: Better database and index management, further query and SP tuning, and more hardware. cheers, Chris Maunder
-
I think Chris would also include a total site rewrite in that list. :) Tim Smith I'm going to patent thought. I have yet to see any prior art.
You got it in one ;) cheers, Chris Maunder
-
The issue isn't the amount of data returned between the SQL and WebServer (though this is important), but rather the work done in scanning tables and indexes (indices?) and sorting the messages to return the messages in the correct threaded order for the specified forum with the specified constraints. Once the messages to be displayed has been determined then actually returning that info is trivial. Forcing the client to implement some kind of XSLT to convert the XML to HTML would mean some browsers simply wouldn't be able to view the information. The solution is: Better database and index management, further query and SP tuning, and more hardware. cheers, Chris Maunder
Chris Maunder wrote: The issue isn't the amount of data returned between the SQL and WebServer (though this is important), but rather the work done in scanning tables and indexes (indices?) and sorting the messages to return the messages in the correct threaded order for the specified forum with the specified constraints. Once the messages to be displayed has been determined then actually returning that info is trivial. You are not seeing the caching oportunities this allows. You don't need to get the forum data from the SQL Server everytime. This way you end up locking tables too much. The volume of data inserted on CP's SQL Server daily is very low (ok, if you are logging IIS on the same SQL Server, forget about it, redirect them to another el-cheapo server. If you are logging to text files, you have serious security problems I would not mention on the Lounge). I would bet you have a 10x1 or 100x1 read x insert&update ratio. So, if the data you are returning from the WebServer have a simpler structure, it can be easily cached on the WebServer, reducing lock contention on the SQL Server. I can see you probably have an index on the message text to prevent duplicate messages. Believe me, if you did it, this is the worst mistake you can make. A better approach would be calculating some hashing on the message and storing it, this would make detecting duplicate messages a no-brainer. Once I started three searches on CP at the same time (it was not my intention) and the whole CP started to get slow for some minutes. It seems you have serious problems here, too. Chris Maunder wrote: The solution is: Better database and index management, further query and SP tuning, and more hardware. I would gladly help in this kind of work, I love to do it. I see dumb people
-
Oh, thanks for asking. Currently we found no partner and doing it for ourself so far. You know, to find a TRUSTWORTHY partner is really really difficulty. Is YOUR company interested? -- - Free Windows-based Web Content Management System: http://www.zeta-software.de/enu/producer/freeware/download.html - Scanned MSDN Mag ad with YOUR name: www.magerquark.de/misc/CodeProject.html - See me: www.magerquark.de
Uwe Keim wrote: Is YOUR company interested? We would be if ZetaProducer ran on ASP and used MS technologies. We are an MS company so all our skills tend towards that.
Paul Watson
Bluegrass
Cape Town, South AfricaChristopher Duncan wrote: Which explains why when Santa asked, "And what do you want for Christmas, little boy?" I said, "A life." (Accesories sold separately)