Line 466:
Line 466:
** chown -R off deleted* html index ingredients lang invalid lists products users tmp
** chown -R off deleted* html index ingredients lang invalid lists products users tmp
−
====== Product opener debug =====
+
+
===== MongoDB indexes =====
+
+
Some basic indexes, needs to be revisited.
+
https://github.com/openfoodfacts/openfoodfacts-server/issues/341
+
+
<pre>
+
mongo
+
use obf
+
+
+
db.products.createIndex( { code : 1 }, { background : true });
+
db.products.createIndex( { unique_scans_n : -1 }, { background : true });
+
db.products.createIndex( { sortkey : -1 }, { background : true });
+
+
db.products.createIndex( { sortkey : -1 }, { background : true });
+
db.products.createIndex( { last_modified_t : -1 }, { background : true });
+
+
db.products.createIndex( { _keywords : 1, last_modified_t : -1 }, { background : true });
+
db.products.createIndex( { _keywords : 1, sortkey : -1 }, { background : true });
+
+
db.products.createIndex( { countries_tags : 1 }, { background : true });
+
+
db.products.createIndex( { countries_tags : 1 , last_modified_t : -1 }, { background : true });
+
db.products.createIndex( { countries_tags : 1 , sortkey : -1 }, { background : true });
+
+
db.products.createIndex( { brands_tags : 1 }, { background : true });
+
db.products.createIndex( { categories_tags : 1 }, { background : true });
+
+
+
+
</pre>
+
+
===== Product opener debug =====
Once Apache starts:
Once Apache starts: