I'm using the Workspace module on a large community site and noticed (like others) that the complex queries used to generate the items list can be a bit expensive.

I resolved this by breaking the workspace into three tab-driven pages: Items, Comments, and Attachments (see attached image). This allowed me to simplify the query and get quicker results from the database.

Hopefully this will help someone else who loves the functionality of this module but struggles with its responsiveness.

CommentFileSizeAuthor
workspace_optimized.patch14.7 KBkmillecam
workspace.gif18.43 KBkmillecam

Comments

jvandyk’s picture

jvandyk commented
Status: Needs review » Closed (fixed)

Thanks for this. The 6.x-1.0 release takes this approach.