WIP: optimization on displaying studies list

I got really tired of how slow is the studies display when having so many studies so I started working on https://github.com/biocore/qiita/issues/601. This is the initial optimization of /private/. I want to have some feedback before working on the others. 
Recommend to use EXPLAIN as well as \timing

On Mon, Nov 24, 2014 at 8:54 AM, Antonio Gonzalez <notifications@github.com>
wrote:

> In qiita_pet/handlers/study_handlers.py:
>
> > +                infolist.append(StudyTuple(study.id, study.title,
> > +                                           info["metadata_complete"],
> > +                                           info["number_samples_collected"],
> > +                                           shared, len(study.raw_data()),
> > +                                           PI, pmids, owner, status))
> > +        else:
> > +            for s in user.user_studies_for_display:
> > +                study_id = s[0]
> > +                title = s[1]
> > +                metadata_complete = s[2]
> > +                samples_collected = s[3]
> > +
> > +                shared = []
> > +                if s[4]:
> > +                    for sh in s[4].split(','):
> > +                        name, email = sh.rsplit('&', 1)
>
> BTW it will be great if you can compare them using \timing.
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/biocore/qiita/pull/679/files#r20798312>.
>