This week was one that I desparately needed. Our sites have been it's most stable this week since our move to chicago.
Still things to do to help with that, but that will be discussed later
1. Cannot Edit or delete posts
2. Editing and/or setting article's status is too slow
3. Within the libraries, the "Top Authors" Section of the right bar wasn't showing correctly.
4. Page Count for article comments was displaying incorrectly. For Example, if there are 4 pages of article replies, it was only showing as having 3, you would actually have to manually type in the url the 4th page.
5. Users could not move his/her posts from one forum to another in certain cases.
These are all bugs i had a chance to get to this week and now are currently SQUISHED!
MISC things done to help with site/server performance:
1. Did some profiling of our sites as usual, and just made sure our key queries weren't taken longer than usual, and noted others that need some TLC
2. Created some stored procedures to help with syncing articles from one db to another so that the process would be much more zippy when editing/deleting/setting status of articles.
3. When creating/editing/deleting an article from your blogsite of JU, it now queue's a job to sync that particular to our articles DB.
4. This task took most of the time this week, but i feel will help us in the long run.
Late last week, one of our external developers who is a whiz at Databases made a suggestion on how to structure a few of our intense queries. Well, Here are a few "things" that his suggestion has made an impact with:
a. Article Comments. Our methods of retrieving article comments wasn't bad, but was very average. this change made a 300% improvement in speed and efficiency.
b. Skin Comments. Similiar to the skin comments, it has made a significant impact in change.
c. Viewing and paging through featured articles
In all, i updated roughly 21 stored procedures to benefit from Alberto's suggestion. I figure i mine as well do it now before it becomes a major issue.
Some Key things that need to be addressed next week:
1. When a skin is created or approved, it doesn't always show up properly throughout the WC Main site as well as that author's personal page.
2. Personal pages!!!! Three key words - "Faster" "Faster" "Faster
we will be concentrating alot on using the new static page system t-man created this week and implementing it within the personal pages so that the browsing experience is much much better.
Well, i'm sure i forgot a few items, but that is it for the week. Have a great weekend! the weather in detroit is beautiful!