Workspace Page Slow

Can anything be done to increase the performance of the Workspace

Page. I hardly ever go to it anymore because it takes so long to

load.

 

Also, the way the photo.net site feedback forums looks is great and a

lot more useful than the old way. Is that going to be implemented to

the other forums?

<a href="http://www.photo.net/bboard/q-and-a-fetch-msg?msg_id=0066md">http://www.photo.net/bboard/q-and-a-fetch-msg?msg_id=0066md</a>

<p>

Doug Burgess made an interesting find and talks about it in that thread.

Blame Bob Atkins.

 

I have just been looking at this, and it is indeed the case that

the slowness is due to your "Interesting People" list, and in particular the "Most Recent Contribution" feature. Patrick Hudepohl and I worked on this several months ago, and optimized it quite a bit, but it is still slowed down considerably by having certain people like Bob on your list, with their thousands of contributions.

 

I'm going to try to optimize this some more. Of course, the other options are (1) ban Bob, or (2) not allow him to be "interesting".

As far as the "Interesting People" feature. I would recommend that you create a field for each user to indicate the date of last contribution that would be updated whenever someone does something new like posts something new. That way you only have to query the one table rather then the messages they have posted. If Bob posts something, if there was a last_activity type field that could be updated in the user table or something like that it should speed things up. Though you would have to make a lot of changes throughout the site to update this field for new postings, images, comments, classifieds, comments, whatever you are currently looking for, the performance gain should be huge if what's happening is what it sounds like is happening. Also create an index on this field.

Also, I didn't get any email alerts for this thread by default.

Works much faster. Actually the whole site seems much faster now. What did you chage?