[OH-Dev] [issue525] /+projects/ consistently loads surprisingly slowly

[jesstess]

jesstess <jessica.mckellar at gmail.com> added the comment:

The attached tarball has a couple of commits:

Speed up /projects by using cheaper ORM queries in get_projects_with_bugs.
Remove buildhelper-mockup.html, which is unused.
Remove unused JS files.

On my desktop, the time difference from the ORM commit looked like this, starting up Django on a 
cold cache:

Before this commit:
- time in projects() (time is per call, function called twice): 1.16
- time in get_projects_with_bugs(): 2.34
    
After this commit:
- time in projects() (time is per call, called twice): 0.19
- time in get_projects_with_bugs(): 0.4

There is more that can be done for this ticket, but if these changes look good it'd be great to get 
them on the live site.

----------
status: in-progress -> need-review

__________________________________________
Roundup issue tracker <bugs at openhatch.org>
<https://openhatch.org/bugs/issue525>
__________________________________________
-------------- next part --------------
A non-text attachment was scrubbed...
Name: issue525.tar.gz
Type: application/x-gzip
Size: 10613 bytes
Desc: not available
URL: <http://lists.openhatch.org/pipermail/devel/attachments/20120108/605dab50/attachment.bin>