Caveat - I imported data into the Gemini database from a previous issue tracker, so I might have done this to myself.

My database has 9000 issues in it; approximately 1600 are not closed.

I'm seeing fairly bad performance when doing several different operations: opening an issue with ViewIssue; clicking on the next issue link, bringing up issues.aspx.

Some operations are very fast: Project.aspx, etc.

I ran SQL Profiler to see what might be going on to my database; it appears that I'm getting tons of individual requests for issues and associated issue data.  I would have hoped for a few SQL requests, instead I'm seeing around 10000.  This takes about 9 seconds to open up a ViewIssue page or the Issues page.  (The project page is less than 1 second).

When I didn't mark items as Closed the problem was much worse.

Is there some caching missing?  Is it just iterating over the issues one at a time?  HUGE performance hit with SQL Server.  Is this a "feature" of NHibernate?

I'd really like to be able to use Gemini for all our consulting, but at this point I can only recommend it for smaller data sets.