title: Webi Rich Client refresh is very slow contrary to Webi and SQL
body: <p>I have a single Universe query that has 4-5 filters that takes almost 5 minutes to run using the Webi rich client.  When I copy the SQL code and run it from SQL management studio (SSMS) it takes 10 seconds.  I have created only the data query and don't have any reports or variables. When I run the query using the Webi HTML, it also runs in 10 seconds.</p>
  
  <p>Both SSMS and Webi return 110,000 rows. If I stop the Webi query after about 20 seconds, it only returned 5000 rows, so it's not finishing and then getting hung up.</p>
  
  <p>If I replace the Webi Universe query with a stored procedure (FHSQL) using the same SQL code, it takes 80 seconds. There are query filters in place. Without the Where clauses, SMSS takes 65 seconds to return 990,000 rows</p>
  
  <pre><code>                 Filtered    All_Records
     # of Rows:     110,000      990,000
     --------------------------------------------
     SQL (SSMS):    10 sec       65 sec
     Webi HTML:     10 sec
     Stored Proc:   80 sec
     Rich client:  270 sec
  </code></pre>
  
  <p>Just the rich client is slow, but much more than would be expected.</p>