title: Comparing performance of SQL query vs Linq
body: <p>My question about searching queries with .NOT . I'm confused which is faster for loading and process SQL query, I have implemented SQL Server query and my query getting larger and slow of fetching data even though I'm using indexing search with SQL Server 2012.</p>
  
  <p>So is there any way to make my query faster with linq?</p>
  
  <p>Here is simple of my query </p>
  
  <pre><code>SELECT
      counting 
  FROM  
      xxxxxxx 
  WHERE
     (Contains(BOOLEANTEXT, '"FORM"')) 
     AND ((Contains(BOOLEANTEXT, ' "FORM"  and  "WARRANT" ' ))) 
     AND ((Contains(BOOLEANTEXT, ' "RETURN"  or  "RESPECTING"  or  "ELECTION"  or  "EXPENSES" ')))  
     OR ((Contains(BOOLEANTEXT, 'Near((FORM,WARRANT,RETURN,RESPECTING,ELECTION,EXPENSES), 1000, TRUE)' ))) 
     AND ((Contains(BOOLEANTEXT, 'FORMSOF(INFLECTIONAL, FORM,WARRANT,RETURN,RESPECTING,ELECTION,EXPENSES)' ))) 
     AND ((Contains(BOOLEANTEXT, 'FORMSOF(THESAURUS, FORM,WARRANT,RETURN,RESPECTING,ELECTION,EXPENSES)' ))) 
  ORDER BY 
     FORMTITLE ASC
  </code></pre>