Do you mean that a CreateFullTextQuery with pagination (SetMaxResults,SetFirstResult) is slower than the same query without pagination ? Please attach a test proving it. Thanks.
On Thu, Mar 17, 2011 at 11:07 AM, Christian Setzkorn <[email protected]>wrote: > Hi, > > This code works fine: > > Query query = parser.Parse(expression); > > IFullTextSession session = Search.CreateFullTextSession(this.Session); > > IFullTextQuery fullTextQuery = session.CreateFullTextQuery(query, new[] { > typeof(MappedSequence) }); > > var l1 = fullTextQuery.List(); > > as long as the query does not return too many objects. If the query > contains too many objects the generated sql code is too long and sql server > throws an exception: > > "The incoming tabular data stream (TDS) remote procedure call (RPC) > protocol stream is incorrect. Too many parameters were provided in this RPC > request. The maximum is 2100." > > One working solution is to obtain all objects using paging which is fairly > slow. Is there a better solution? > > Thanks. > > C > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
