title: SAPUI5 filter table performance
body: <p>I have a table with 3 columns holding at most 6000 elements. Above that table I have a <code>SearchField</code>. When something is typed into the <code>SearchField</code>, the table is filtered by 2 of the 3 columns (using <code>liveChange</code>) like this:</p>
  
  <pre><code>var oTable = this.getView().byId("idMyTable");
  var oBinding = oTable.getBinding("items");
  oBinding.filter(new sap.ui.model.Filter([
                      new sap.ui.model.Filter("col1", sap.ui.model.FilterOperator.Contains, sInput),
                      new sap.ui.model.Filter("col2", sap.ui.model.FilterOperator.Contains, sInput),
  
                  ], false), "Application");
  </code></pre>
  
  <p>While this solutions works, it needs almost <strong>5 seconds</strong> to complete (for only 6000 elements in the table) and another bit of time until the data in the table is displayed again.</p>
  
  <p>When the table is being filled, its size limit is set to the length of data which is in the model:</p>
  
  <pre><code>// rs0 is the result set of the db query which contains the data
  tableModel.setSizeLimit(tableModel.getData().rs0.length);
  </code></pre>
  
  <p>When I omit the call for <code>setSizeLimit</code> the search is quiet fast but I can't scroll through all items in the table (not everything is displayed).</p>
  
  <p>My questions is: How can I display all values in the table and keep a good search performance at the same time?</p>
  
  <p>Thanks in advance!</p>