I've added a new issue https://github.com/biocore/qiita/issues/57 for the performance tests (I don't think they should be blocking this PR).

In terms of the complex queries, they will be coming once the objects are in place (specially once the Search object is implemented). The goal of these tests is just to check that we do not screw up the SQL layout and we are able to load data to the DB. Shouldn't block this PR (there is an issue for each object)