Changes

Jump to navigation Jump to search
1,095 bytes added ,  08:46, 5 July 2016
→‎Product Opener: mongodb indexes
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:

Navigation menu