JozefSevcik
unread,Jan 29, 2009, 12:55:49 PM1/29/09Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to nhusers
Hi all,
just starting with NH.Search, NH trunk, NH.Search trunk.
using (IFullTextSession s = ...
{
string q = "Code:ALPHA";
var result = s.CreateFullTextQuery<Customer>(q)
.List<Customer>();
}
250 Documents in Lucene are relevant for this query, for example.
Problem:
Expected 1 SQL query produced by NHibernate:
select a,b,c from Customer where Id in (IDs-returned-by-lucene)
But instead of this, NHibernate produces 250 SQL queries,
each with 'where id = x', namely for every Id returned from lucene it
produces query.
Am I missing something ?
Thank you !