Advertisement
tracker1

Error in mongodb...

Dec 21st, 2012
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //with the following index...
  2.   db.listings.ensureIndex({'_meta.sort_date':-1,listing_id:-1});
  3.  
  4. //GIVEN THE FOLLOWING INPUTS...
  5.   var sort= [["_meta.sort_date",-1],["_meta.listing_id",-1]];
  6.   var find= {"listing_status":"active"};
  7.   var fields = {
  8.     "listing_id":true,"_meta.sort_date":true,"_meta.vyear":true,"_meta.vmake":true
  9.     ,"_meta.vmodel":true,"_meta.vpkg":true,"contact":true,"tags":true
  10.     ,"vehicle.vin":true,"vehicle.mfg_make":true,"vehicle.mfg_model":true
  11.     ,"vehicle.mfg_year":true,"vehicle.mfg_package":true,"vehicle.images.url_thumb":true
  12.     ,"desc_html":true,"price":true,"is_obo":true,"_id":false
  13.   };
  14.   var sort = [["_meta.sort_date",-1],["_meta.listing_id",-1]];
  15.   var skip = 20420;
  16.   var limit = 10;
  17.  
  18. //I run the following
  19.   db.listings.find(find,fields).sort(sort).limit(limit).skip(skip);
  20.  
  21. //At the mongodb console, no problem, runs fine...
  22.  
  23. //via Node's adapter, I get the following error...
  24. "too much data for sort() with no index.  add an index or specify a smaller limit"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement