I need help. I've been using this hack since it was first released for vb3 and so my users have accumulated large amounts of posts in their journals. The problem is that regardless of the pagination, the larger their journal, the longer it takes to load and the heavier it is on server resources. For some users, I click on their journal link and come back 5 minutes later. If enough people are browsing journals, it brings my server to its knees. This isn't how things should work.
So, I'm faced with a decision - either clean up this hack myself, or find a new way for users to keep journals. Has anyone had to do any work on the queries to make them more efficient? Please please help!
|