SharePoint 2010 Search issue on Row limit on search scope

We are working on SharePoint 2010 project and using SharePoint 2010 Enterprise Search service Application.

We have implemented search content Source, scope and properties by Power shell script and having Business Connectivity Service external content types to crawl on content source from custom SQL server data base of application. Now when user search in application by keyword we just build a dynamic select query in code and execute on defined scope. While building the dynamic select query we need to set a parameter called Row Limit. Please find the code snippet below :

string

query = "SELECT MFRREF,MFRID, MFRNICK, MFRCNT, MFRCITY, MFRPLANT, MFRSTATUS,MFRLOGO,MFRDATASTATUSVALUE,MFRISACTIVE, MFRCOPYTEXT,"+

                                           

"MFRACCGRP,MFRAUTHGRP,MFRMATGRP,MFRTIME,MFRREFCAT, "+

                                           

" Rank "+

                                           

" FROM SCOPE() "+

                                           

" WHERE "+

                                           

" \"SCOPE\" = 'TmaMnfr' "+

                                           

" AND FREETEXT(*, '"+ keyword + "') "+

                                           

" ORDER BY rank desc";

                           

FullTextSqlQueryfullTextQuery =

                                                    

newFullTextSqlQuery(SPContext.Current.Site)

                                                     {

                                                         ResultTypes =

ResultType.RelevantResults,

                                                         EnableStemming =

true,

                                                         TrimDuplicates =

true,

                                                         KeywordInclusion =

KeywordInclusion.AnyKeyword,

                                                        

RowLimit = 5000,


                                                         QueryText = query,

                                                         IgnoreAllNoiseQuery =

false


                                                     };



We have set 5000 to the row limit properly but in application search , the row count may exceed more than 1000000. Now the question is, is there any limit which is set by Microsoft or there is a way out to fix the problem so that the search can handle more than 1000000 rows.

Seeking for your answer or assistance at earliest as currently we are stuck.

August 6th, 2013 6:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics