When you run the query manually, might it be that you have converted the parameters to embedded constants? You can try to run the query directly through ADO.NET, keeping the parameters as parameters.
Does the query involve correlated subqueries? /Oskar 2013/1/30 <[email protected]>: > That's the thing, we have tried that, and there's no difference with or > without the index. The query itself doesn't take any time at all, but when > using QueryOver without the index, it takes 110 seconds to return the data > objects, with a manually created index it takes 7.5 seconds, and with a > scripted index it still takes 110 seconds. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
