Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Slow query performance even in nodejs #4902

Closed
kevinprotoss opened this issue Feb 18, 2016 · 1 comment
Closed

Slow query performance even in nodejs #4902

kevinprotoss opened this issue Feb 18, 2016 · 1 comment

Comments

@kevinprotoss
Copy link

Hi together,

I just want to ask what's the performance you have.

I did a simple test like the following code in nodejs with levelDB.

Init DB:

let PouchDB = require('pouchdb');
let db = new PouchDB('test-query');

let data = [];

for (var i=0; i<120; i++) {
    data.push({
        value: Math.random()        
    });
}

db.bulkDocs(data).then(function() {
  // success
  var ddoc = {
    _id: '_design/my_index',
    views: {
      by_value: {
        map: function mapFun(doc) {
          emit(doc.value);
        }.toString()
      }
    }
  };

  db.put(ddoc).catch(function (err) {
    if (err.status !== 409) {
      throw err;
    }
    // ignore if doc already exists
  }).then(function () {
    return db.query('my_index/by_value');
  }).catch(function (err) {
    console.log(err);
  });
}).catch(function (err) {
  // ouch, an error
});

Query:

let PouchDB = require('pouchdb');
let db = new PouchDB('test-query');

console.time('find');
db.query('my_index/by_date', {
    startkey: 0.5,
    endkey: 1,
    include_docs: false
}).then(function(result) {
    console.timeEnd('find');
    console.log(result.rows.length);
    // console.log('result', result.docs.length, JSON.stringify(result, null, 2));
}).catch(function (err) {
  // ouch, an error
});

It takes always about 1200ms for each query. There are only 120 entries in the data. Why should it take so long time to make a range query? Have I done something wrong?

The following is the output in debug mode:

DEBUG=pouchdb:* node test-query.js
  pouchdb:adapter Picked adapter: leveldb +0ms
  pouchdb:api test-query +26ms get _design/my_index
  pouchdb:api test-query +460ms get _design/my_index
  pouchdb:api test-query +6ms get success { views: { by_date: { map: 'function mapFun(doc) {\n        emit(doc.value);\n      }' } },
  _id: '_design/my_index',
  _rev: '1-634bdeec928765bfe987ed226a8e3d24' }
  pouchdb:api test-query +29ms info
  pouchdb:api test-query +1ms get success { views: { by_date: { map: 'function mapFun(doc) {\n        emit(doc.value);\n      }' } },
  _id: '_design/my_index',
  _rev: '1-634bdeec928765bfe987ed226a8e3d24' }
  pouchdb:api test-query +1ms info success { doc_count: 121,
  update_seq: 121,
  backend_adapter: 'LevelDOWN',
  db_name: 'test-query',
  auto_compaction: false,
  adapter: 'leveldb' }
  pouchdb:api test-query +2ms get _local/mrviews
  pouchdb:api test-query +0ms get success { views: { 'my_index/by_date': { 'test-query-mrview-82cce15398b815bd6611c3ffb7b32d93': true } },
  _id: '_local/mrviews',
  _rev: '0-1' }
  pouchdb:api test-query +2ms registerDependentDatabase test-query-mrview-82cce15398b815bd6611c3ffb7b32d93
  pouchdb:adapter Picked adapter: leveldb +1ms
  pouchdb:api test-query +2ms get _local/_pouch_dependentDbs
  pouchdb:api test-query +0ms get success { dependentDbs: { 'test-query-mrview-82cce15398b815bd6611c3ffb7b32d93': true },
  _id: '_local/_pouch_dependentDbs',
  _rev: '0-1' }
  pouchdb:api test-query +1ms registerDependentDatabase success { db: 
   PouchDB {
     __opts: {},
     auto_compaction: undefined,
     prefix: '_pouch_',
     domain: null,
     _events: {},
     _eventsCount: 0,
     _maxListeners: undefined,
     taskqueue: TaskQueue$1 { isReady: false, failed: false, queue: [] },
     _adapter: 'leveldb',
     _db_name: 'test-query-mrview-82cce15398b815bd6611c3ffb7b32d93',
     adapter: 'leveldb',
     replicate: { from: [Function], to: [Function], sync: [Function] },
     sync: [Function],
     type: [Function],
     _id: [Function],
     _info: [Function],
     _get: [Function],
     _getAttachment: [Function],
     _bulkDocs: [Function],
     _allDocs: [Function],
     _changes: [Function],
     _close: [Function],
     _getRevisionTree: [Function],
     _doCompaction: [Function],
     _doCompactionNoLock: [Function],
     _getLocal: [Function],
     _putLocal: [Function],
     _putLocalWithLock: [Function],
     _putLocalNoLock: [Function],
     _removeLocal: [Function],
     _removeLocalWithLock: [Function],
     _removeLocalNoLock: [Function],
     _destroy: [Function],
     then: [Function: bound then],
     catch: [Function: bound catch] } }
  pouchdb:api test-query-mrview-82cce15398b815bd6611c3ffb7b32d93 +3ms get _local/lastSeq
  pouchdb:api test-query-mrview-82cce15398b815bd6611c3ffb7b32d93 +681ms get _local/lastSeq
  pouchdb:api test-query-mrview-82cce15398b815bd6611c3ffb7b32d93 +0ms get success { _id: '_local/lastSeq', seq: 121, _rev: '0-3' }
  pouchdb:api test-query-mrview-82cce15398b815bd6611c3ffb7b32d93 +14ms get success { _id: '_local/lastSeq', seq: 121, _rev: '0-3' }
  pouchdb:api test-query-mrview-82cce15398b815bd6611c3ffb7b32d93 +10ms allDocs { startkey: '5323235\u0000\u0000',
  endkey: '5323241\u00006\u0000\u0000',
  skip: 0,
  include_docs: true }
  pouchdb:api test-query-mrview-82cce15398b815bd6611c3ffb7b32d93 +18ms allDocs success { total_rows: 120,
  offset: 0,
  rows: 
   [ { id: '5323235.04442907171323895454\u00004053C7603-E5D9-3B0D-B0CE-D0033F585B24\u0000\u0000',
       key: '5323235.04442907171323895454\u00004053C7603-E5D9-3B0D-B0CE-D0033F585B24\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.09963126154616475105\u00004B8E2866B-0C85-EE9A-BBFF-C2CD644F856D\u0000\u0000',
       key: '5323235.09963126154616475105\u00004B8E2866B-0C85-EE9A-BBFF-C2CD644F856D\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.1171130291186273098\u0000449A2B23D-8879-6BAD-A90B-8976BB1DC47C\u0000\u0000',
       key: '5323235.1171130291186273098\u0000449A2B23D-8879-6BAD-A90B-8976BB1DC47C\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.19881535321474075317\u00004AC142950-34A8-58E0-8F0E-34E941208F69\u0000\u0000',
       key: '5323235.19881535321474075317\u00004AC142950-34A8-58E0-8F0E-34E941208F69\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.242387428879737854\u000041B444B64-3D15-DDAE-8728-C4A9352DEBBC\u0000\u0000',
       key: '5323235.242387428879737854\u000041B444B64-3D15-DDAE-8728-C4A9352DEBBC\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.2488233405165374279\u0000423FC8107-D51F-85D8-9C59-3DCAF7A9DDBD\u0000\u0000',
       key: '5323235.2488233405165374279\u0000423FC8107-D51F-85D8-9C59-3DCAF7A9DDBD\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.36256800871342420578\u00004E4632FB8-B457-0914-B33E-0B85AE6BD35F\u0000\u0000',
       key: '5323235.36256800871342420578\u00004E4632FB8-B457-0914-B33E-0B85AE6BD35F\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.37016980815678834915\u00004ACFE685B-AE3D-4F78-AC66-1A4BEF2A2772\u0000\u0000',
       key: '5323235.37016980815678834915\u00004ACFE685B-AE3D-4F78-AC66-1A4BEF2A2772\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.90333046158775687218\u00004A24EB08E-1C36-4028-B8EF-AAFD525F38C0\u0000\u0000',
       key: '5323235.90333046158775687218\u00004A24EB08E-1C36-4028-B8EF-AAFD525F38C0\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.96417815657332539558\u00004649998CA-27CB-7C36-A33D-B808E69AE0A1\u0000\u0000',
       key: '5323235.96417815657332539558\u00004649998CA-27CB-7C36-A33D-B808E69AE0A1\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323235.96750062424689531326\u000042272110B-27B4-2950-9DB1-F7EC592D95B9\u0000\u0000',
       key: '5323235.96750062424689531326\u000042272110B-27B4-2950-9DB1-F7EC592D95B9\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.05015794979408383369\u000040AB4A577-7D93-33DE-BFE5-97DD6805DDC4\u0000\u0000',
       key: '5323236.05015794979408383369\u000040AB4A577-7D93-33DE-BFE5-97DD6805DDC4\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.10403853002935559147\u0000467F1CE90-833B-A0D7-B863-529B6BB93D38\u0000\u0000',
       key: '5323236.10403853002935559147\u0000467F1CE90-833B-A0D7-B863-529B6BB93D38\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.14608435891568660736\u00004008050A7-9789-696E-BB88-B3DFE5D5D97B\u0000\u0000',
       key: '5323236.14608435891568660736\u00004008050A7-9789-696E-BB88-B3DFE5D5D97B\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.33835179032757878304\u00004FD14DAB1-44C7-1F81-80E8-1EA1EF060D8F\u0000\u0000',
       key: '5323236.33835179032757878304\u00004FD14DAB1-44C7-1F81-80E8-1EA1EF060D8F\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.38196666724979877472\u00004FFCA9AD8-9C2E-F967-A739-C49A05853557\u0000\u0000',
       key: '5323236.38196666724979877472\u00004FFCA9AD8-9C2E-F967-A739-C49A05853557\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.64756562793627381325\u00004BE2E115A-51B1-8FFC-A90D-E069704886EE\u0000\u0000',
       key: '5323236.64756562793627381325\u00004BE2E115A-51B1-8FFC-A90D-E069704886EE\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.7150948522612452507\u000049B7D6380-0085-7DEC-80A4-A0DE6CE9BABC\u0000\u0000',
       key: '5323236.7150948522612452507\u000049B7D6380-0085-7DEC-80A4-A0DE6CE9BABC\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.78492756094783455723\u0000470AD4D79-298F-979B-BA03-E2224BD25941\u0000\u0000',
       key: '5323236.78492756094783455723\u0000470AD4D79-298F-979B-BA03-E2224BD25941\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.89780707703903317451\u000044DB9A6DD-D2E2-F225-B2DB-6E10EA109161\u0000\u0000',
       key: '5323236.89780707703903317451\u000044DB9A6DD-D2E2-F225-B2DB-6E10EA109161\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323236.94067464908585041172\u00004F0676DF4-993F-1F0C-B9EA-680C0572C038\u0000\u0000',
       key: '5323236.94067464908585041172\u00004F0676DF4-993F-1F0C-B9EA-680C0572C038\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.0188782992772758007\u000048663D614-3516-3AED-8A71-8611721D9C37\u0000\u0000',
       key: '5323237.0188782992772758007\u000048663D614-3516-3AED-8A71-8611721D9C37\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.21672363346442580223\u00004E74348FA-0924-E9D0-9FF4-FAD210B1F778\u0000\u0000',
       key: '5323237.21672363346442580223\u00004E74348FA-0924-E9D0-9FF4-FAD210B1F778\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.31716509908437728882\u000045F5ABE4C-7C92-EF0C-B94B-63C94CE05822\u0000\u0000',
       key: '5323237.31716509908437728882\u000045F5ABE4C-7C92-EF0C-B94B-63C94CE05822\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.38209349801763892174\u00004410931C6-7983-9989-98E6-0695C0FA38BB\u0000\u0000',
       key: '5323237.38209349801763892174\u00004410931C6-7983-9989-98E6-0695C0FA38BB\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.38998490385711193085\u000045C55E611-D166-3C38-ABE6-E01AE0F2FAA3\u0000\u0000',
       key: '5323237.38998490385711193085\u000045C55E611-D166-3C38-ABE6-E01AE0F2FAA3\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.44265613378956913948\u000040238D426-C858-BF98-8965-4693D346F00B\u0000\u0000',
       key: '5323237.44265613378956913948\u000040238D426-C858-BF98-8965-4693D346F00B\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.75853239931166172028\u000043E7354DD-A8F1-79BC-AB72-46712ED9351C\u0000\u0000',
       key: '5323237.75853239931166172028\u000043E7354DD-A8F1-79BC-AB72-46712ED9351C\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.85870517371222376823\u000040A9328E2-11DB-43B4-8C47-D41E38ECB741\u0000\u0000',
       key: '5323237.85870517371222376823\u000040A9328E2-11DB-43B4-8C47-D41E38ECB741\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323237.87468709517270326614\u0000403A40AF3-5EA0-19AE-98EB-ED2B7B6F637D\u0000\u0000',
       key: '5323237.87468709517270326614\u0000403A40AF3-5EA0-19AE-98EB-ED2B7B6F637D\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.03426597500219941139\u00004FCC45183-7F2C-D146-BEE8-EA4C20EEAA2D\u0000\u0000',
       key: '5323238.03426597500219941139\u00004FCC45183-7F2C-D146-BEE8-EA4C20EEAA2D\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.0776427779346704483\u0000417616F22-B854-B2BA-B6B7-31A7CBC1A8A3\u0000\u0000',
       key: '5323238.0776427779346704483\u0000417616F22-B854-B2BA-B6B7-31A7CBC1A8A3\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.10526856454089283943\u00004AB2CFF22-AE51-EC2C-AA5B-A0B0AF271312\u0000\u0000',
       key: '5323238.10526856454089283943\u00004AB2CFF22-AE51-EC2C-AA5B-A0B0AF271312\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.10950837796553969383\u000040D497F96-06DC-7DB3-B638-6A0064BFC25B\u0000\u0000',
       key: '5323238.10950837796553969383\u000040D497F96-06DC-7DB3-B638-6A0064BFC25B\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.17699530161917209625\u0000419FC676E-AC4B-1105-925B-39323E7ACAFC\u0000\u0000',
       key: '5323238.17699530161917209625\u0000419FC676E-AC4B-1105-925B-39323E7ACAFC\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.23367898818105459213\u00004C6668E5D-9C8F-3BAA-AD9A-0BF75712CC4C\u0000\u0000',
       key: '5323238.23367898818105459213\u00004C6668E5D-9C8F-3BAA-AD9A-0BF75712CC4C\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.32664042944088578224\u00004E5B4640E-C595-0038-BEE8-8587799E8412\u0000\u0000',
       key: '5323238.32664042944088578224\u00004E5B4640E-C595-0038-BEE8-8587799E8412\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.33164332667365670204\u00004087E17B0-9893-3F37-AED7-7D8D6AE4446F\u0000\u0000',
       key: '5323238.33164332667365670204\u00004087E17B0-9893-3F37-AED7-7D8D6AE4446F\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.36554989684373140335\u00004B3D67915-12F3-B0D2-98A2-B41A6057A6E3\u0000\u0000',
       key: '5323238.36554989684373140335\u00004B3D67915-12F3-B0D2-98A2-B41A6057A6E3\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.38313400046899914742\u000046AB6293C-6F07-7CC6-838E-D6C1766C4256\u0000\u0000',
       key: '5323238.38313400046899914742\u000046AB6293C-6F07-7CC6-838E-D6C1766C4256\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.58313566539436578751\u000047F1EA6A2-C506-1724-B664-5D4EA1D9E0EF\u0000\u0000',
       key: '5323238.58313566539436578751\u000047F1EA6A2-C506-1724-B664-5D4EA1D9E0EF\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.65978740155696868896\u000047A19B82E-6BE1-141C-9A43-3E88D721CFFD\u0000\u0000',
       key: '5323238.65978740155696868896\u000047A19B82E-6BE1-141C-9A43-3E88D721CFFD\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.73993864981457591057\u00004FA5A06BB-2C0C-91B8-8EBD-B6C19A2AC4E0\u0000\u0000',
       key: '5323238.73993864981457591057\u00004FA5A06BB-2C0C-91B8-8EBD-B6C19A2AC4E0\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.76870063366368412971\u0000482B614B3-8E15-35E5-BDF3-441D8D4CB307\u0000\u0000',
       key: '5323238.76870063366368412971\u0000482B614B3-8E15-35E5-BDF3-441D8D4CB307\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.88454968342557549477\u00004D7238EF3-D9C1-7A29-8CEF-BCA101AD2B48\u0000\u0000',
       key: '5323238.88454968342557549477\u00004D7238EF3-D9C1-7A29-8CEF-BCA101AD2B48\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323238.91239747870713472366\u00004B60E1A08-16ED-22BB-A399-66EF62CBC827\u0000\u0000',
       key: '5323238.91239747870713472366\u00004B60E1A08-16ED-22BB-A399-66EF62CBC827\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.05308542540296912193\u00004F83B644B-B88D-4557-8CFC-CDAD4922755F\u0000\u0000',
       key: '5323239.05308542540296912193\u00004F83B644B-B88D-4557-8CFC-CDAD4922755F\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.06954266829416155815\u00004B01D6728-630E-4FEA-9800-4C49BFE40435\u0000\u0000',
       key: '5323239.06954266829416155815\u00004B01D6728-630E-4FEA-9800-4C49BFE40435\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.12170626921579241753\u00004E8C8AC81-E470-298C-AB15-D159570612DD\u0000\u0000',
       key: '5323239.12170626921579241753\u00004E8C8AC81-E470-298C-AB15-D159570612DD\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.18594458373263478279\u00004132128C3-F386-BC6A-AA7E-A8B4E01A6A3E\u0000\u0000',
       key: '5323239.18594458373263478279\u00004132128C3-F386-BC6A-AA7E-A8B4E01A6A3E\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.19001708272844552994\u000046154D6F2-D57A-98C9-B661-CB6C11EADAE7\u0000\u0000',
       key: '5323239.19001708272844552994\u000046154D6F2-D57A-98C9-B661-CB6C11EADAE7\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.46706975577399134636\u00004548F950D-61EA-4A75-BE9F-1BC1274910DE\u0000\u0000',
       key: '5323239.46706975577399134636\u00004548F950D-61EA-4A75-BE9F-1BC1274910DE\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.48040488874539732933\u000046F5EC642-B50E-2AAF-BAB4-B632F9C847FA\u0000\u0000',
       key: '5323239.48040488874539732933\u000046F5EC642-B50E-2AAF-BAB4-B632F9C847FA\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.55951813375577330589\u00004C4956AAF-D4CB-00DF-BFD5-443A76970774\u0000\u0000',
       key: '5323239.55951813375577330589\u00004C4956AAF-D4CB-00DF-BFD5-443A76970774\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.57503476645797491074\u00004A14B6B74-94E0-AB58-9F9A-646333238D3D\u0000\u0000',
       key: '5323239.57503476645797491074\u00004A14B6B74-94E0-AB58-9F9A-646333238D3D\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.59886136464774608612\u00004E8950EBD-8C26-4DE2-95EA-8ABC45401A37\u0000\u0000',
       key: '5323239.59886136464774608612\u00004E8950EBD-8C26-4DE2-95EA-8ABC45401A37\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.62245377479121088982\u00004341AF48A-A959-0B8C-9514-4A99DFB17C0E\u0000\u0000',
       key: '5323239.62245377479121088982\u00004341AF48A-A959-0B8C-9514-4A99DFB17C0E\u0000\u0000',
       value: [Object],
       doc: [Object] },
     { id: '5323239.9335498269647359848\u000049A83B535-ECA0-CEEA-B7C0-F71D5FA3C473\u0000\u0000',
       key: '5323239.9335498269647359848\u000049A83B535-ECA0-CEEA-B7C0-F71D5FA3C473\u0000\u0000',
       value: [Object],
       doc: [Object] } ] }
find: 1253.986ms

Who can give any suggestion for my query?

btw., I tried to use pouchdb-find plugin as well. I found if I called createIndex before find function, the query takes less time, such as 50ms. However, createIndex call still needs 1000ms always.
If I call find function without createIndex, the query takes also 1200ms, just like map reduce query. What has createIndex done?
@nolanlawson
Copy link
Member

Secondary query performance is currently one of the big flaws on PouchDB. We have lots of plans to fix it, but nothing solid yet.

Thanks a lot for reporting the issue; sorry that I can't provide much more guidance here, beyond posting some links:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@nolanlawson @kevinprotoss