I did change "Community_CommentsGetComments" to use dbo.Community_GetContentItemByContentPageID(@communityID, @userID, @currentDate, @contentPageID) Content

Seems to be a lot faster however the comments no longer display and there might be other issues.

Thanks mumfie2003,

But that is not the solution for me. I need the comments fully available.

If you find any solution, please tell me. I will do so.

Thanks.

euroiranian
I have done a preliminary mod to dbo.Community_CommentsGetComments to overcome this problem.
You might wish to install it locally to see if it overcomes your problem.

You can download the mod from
http://www.colin-munford.me.uk/community/Programming/Downloads/Default.aspx

Please note this is a preliminary version and has not been fully tested so please report any issues you encounter.

Hi mumfie2003,

First al all thanks for your effor.

I donwloaded the fix, but I don't know how to install it (Remember I'm a beginner in these matters). Can you detail how to install?

If I don't misunderstand, First I must create a new Function (in User Defined Fuctions) with the first part of your code (from Ln1, Col 1 to Ln 113, Col3) and then modify the existent SP "Community_CommentsGetComments" with the rest of your code (from Ln 116, Col1 to Ln 166, Col 3). Am I right?

Thanks.

Hi again,

Thanks, thanks and thanks. Really helpfull your mod. I'm euphoric.

I've installed your mod following my own instructions and at the moment I can see the articles in full without problem, but I noticed that moderation have the same problem (after and before your fix).

Thanks again, really I can't believe it's working. I will inform you immediately about any eventuality.

Mumfie2003

I'm testing several ways to observe the possible problems. I found that the search engine don't work in this community.

Hi Mumfie2003,

I didn't heard from you for two days now and I want to know if you (or someone else) have done something about the two errors I reported (search engine and moderation). Thanks.

Also I'm having some problem to install your Random photos Webbox Mod. I've installed it following your instalation instructions, but probably I'm missing something.

1.- I created a .acsx file at \Communities\Common\WebBoxes\CM_Random Photos.ascx (copy/pasted from your Website)
2.- I created a SP with your file CM_Community_PhotoGalleryGetRandomPhotos.sql
3.- I intregrated the code of PhotoUtility.cs.txt at the end of my PhotoUtility.cs file at \Engine\Modules\PhotoGallery\Components (Note that the path you supplied is a little bit diferent).
4.- I added it between the webboxes to display (admin section).
Note that I get a blank small box on the page, but none imagen or text init. What I'm doing wrong?

Thanking again your efforts. Tomas.

Hi euroiranian,
I did post a beta version of fix for the "Moderate" option at
http://www.colin-munford.me.uk/community/Programming/Downloads/Downloads_GetFile.aspx?id=595

I am not sure if it is possible to resolve the search issue without significant database changes. There are several limitations of the current search method anyway
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=532330

Not sure why your random photos are not working. Did you rebuild the DLL ?

Hi Mumfie2003,

Thanks again for your fixes. I will install it later and report you if needed.

About Search, that was a bad new. Think how complicate can be find a page in a large site (up to 20.000 pages between 4 communities) for users (most of them inexperts users). But what can I do? Anyway your fixes are excelent and I thank you a lot for them. If you find a solution let me know.

The other issue is the Random Photos. I didn't touch the DLL. Can be there any other reason?

Tomas.

Hi euroiranian,
With the search problem I suggest you post a seperate message on the CSK and GCN forums as it is possible a fix is available or a SQL expert could look at the SP Community_SearchGetSearchResults to find a solution to cater for a large number of content pages in a community/section.

With the random webbox problem you need to recompile the project "CSKDotNet.csproj" using Visual Studio.net to rebuild the dll "ASPNET.StarterKit.Communities.dll". You should then be able to test it locally then deploy the DLL etc to you server.

HTH

Hi Mumfie2003,

Thanks a lot for your help. I installed your fixes and, at the moment, are working right. If any issue with them, I will inform you immediately.

As you suggested, I posted separate messages to both forums, CSK & GCN but not answer at the moment. I will wait, but allow me to considerer you more than an expert in SQL. You solved a big dilemma for me and I learned a lot from your fixes. Many experts are not able to learn nothing. I really appreciate what you did for me and all of us must give you a grade of excellent.

About Random Webbox, I'm to novice to do that. I think I must forget this option at the moment. Someday...!!!

Once more thank you and you have my most high grade as SQL expert. I know, I don't know nothing about SQL, but ....

Thomas

The premise of this MOD is to address the poor performance of the Search feature of the CSK.

This is a drop-in replacement for the Community_GetSearchResults SQL stored procedure. One additional file is required that creates a function that actually performs the search.


See ReadMe file for fine tuning.


http://wbcb.com/TechTips/Downloads/2720.aspx

see related performance article here:

http://wbcb.com/TechTips/CSK+Articles/2717.aspx

Hi Jody,

Thanks for your fix. I installed it and is working wonderfully (still in test. If any issue, I will report)

With your and Mumfie's help my communities are working right and the response times are much better than before.

Again thanks to all this community and very very especially to both of you.


Jody's fix source: http://wbcb.com/TechTips/Downloads/2720.aspx

Mumfie fix source: http://www.colin-munford.me.uk/community/Programming/Downloads/Default.aspx


Thomas.

BTW I tested in GCN and Jody's fix works.

There is very useful article explaining why this error occured.
Please have a look on the this article

http://www.tipsstation.com/article/Timeout-expired-server-is-not-responding-Asp-Dot-Net.aspx