pouchdb queries are very slow on mobile app react native expo

[bilalswiftsolutions]

Issue

I am using pouchdb db form react native expo app and expo-sqlite as an adapter, but the problem is queries are very slow on mobile device as compare to browser.
find query take take 6 minutes to execute without indexes, if I create indexes , createIndex() takes 10 minutes to execute
allDocs is compareablly fast but still it takes 10 seconds to fetch 34000 docs which takes less than 1 second in the browser.
i dont know if this is how pouchdb suppose to work on mobile devices or I am doing something wrong

here is my configuration code

// import "react-native-get-random-values";
import PouchDB from "pouchdb-core";
// import rel from "relational-pouch";

import find from "pouchdb-find";
import HttpPouch from "pouchdb-adapter-http";
import replication from "pouchdb-replication";
import mapreduce from "pouchdb-mapreduce";
import SQLiteAdapterFactory from "pouchdb-adapter-react-native-sqlite";
import * as SQLite from "expo-sqlite";
import pouchdbLoad from "pouchdb-load";
import { polyfillWebCrypto } from "expo-standard-web-crypto";

const SQLiteAdapter = SQLiteAdapterFactory(SQLite);
import rel from "./relational-pouch";
polyfillWebCrypto();

PouchDB.plugin(HttpPouch)
  .plugin(replication)
  .plugin(mapreduce)
  .plugin(pouchdbLoad)
  .plugin(SQLiteAdapter)
  .plugin(find)
  .plugin(rel);

const localdb = new PouchDB("siloc", {
  adapter: "react-native-sqlite",
  auto_compaction: true
});


const remotedb = new PouchDB("https://v2.domain.xyz/siloc", {
  auth: {
    username: ***
    password: ***,
  },
  
});

Info

• Environment: : React native expo sdk 49
• Platform: Android
• Adapter: "react-native-sqlite",
• Server: couchdb server

Reproduce

try pouchdb with expo-sqlite

[Mica4DEV]

Just a question to add more context, why would you do a SELECT * FROM table on 34 000 records in a real world scenario in the first place ?

Do you have an example of documents that you have stored in the database and the createIndex that you're trying to execute ?

If you change the default adapter does it change something in the performance issue you're having?