0037534: Brand query in local database takes long and Web POS sometimes crashes

diff --git a/web/org.openbravo.retail.posterminal/js/model/brand.js b/web/org.openbravo.retail.posterminal/js/model/brand.js
--- a/web/org.openbravo.retail.posterminal/js/model/brand.js
+++ b/web/org.openbravo.retail.posterminal/js/model/brand.js
@@ -36,5 +36,14 @@
     type: 'TEXT'
   }]);
 
+  Brand.addIndex([{
+    name: 'obpos_in_brandproduct',
+    columns: [{
+      name: 'm_product_id',
+      sort: 'asc'
+    }]
+  }]);
+
+
   OB.Data.Registry.registerModel(Brand);
-}());
\ No newline at end of file
+}());
diff --git a/web/org.openbravo.retail.posterminal/js/model/product.js b/web/org.openbravo.retail.posterminal/js/model/product.js
--- a/web/org.openbravo.retail.posterminal/js/model/product.js
+++ b/web/org.openbravo.retail.posterminal/js/model/product.js
@@ -239,7 +239,13 @@
       name: 'productType',
       sort: 'asc'
     }]
+  }, {
+    name: 'obpos_in_productbrand',
+    columns: [{
+      name: 'brand',
+      sort: 'asc'
+    }]
   }]);
 
   OB.Data.Registry.registerModel(Product);
-}());
\ No newline at end of file
+}());