title: What is best option to store list in room android
body: <p>I have object from backend:</p>
  
  <pre><code>class ProductsDTO {
      @PrimaryKey
      var productId: Long = 0
      @TypeConverters(ProductConverter::class)
      var productsList: List&lt;ProductDTO&gt;
      var status: String
  
      constructor(productsList: List&lt;ProductDTO&gt;, status: String) {
          this.productsList = productsList
          this.status = status
      }
  }
  </code></pre>
  
  <p>for now I store in database as table Products where I have 3 tables: productId, productList and status.
  In future I want to use some filters to get product from <code>productsList</code> and I was wondering which would be faster: save products list to another table and search in db using query or load into memory productsList and filter by params?</p>