I cannot run the query without paging in the first place. so i take the data in chunks using paging. this takes a bit of time though. I am just curious why i cannot obtain all objects in one go? I know why, looking at the sql though ... as the generated sql is too long. maybe there is no other way as the query used ... where id in (long list of ids).
On Mar 17, 4:09 pm, Fabio Maulo <[email protected]> wrote: > 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.
