Remove `_executionStack` due to performance issues

[0Ams]

Prerequisites

• I have written a descriptive issue title

Mongoose version

8.6.3

Node.js version

v18.20.4

MongoDB version

4.4.25

Operating system

Linux

Operating system version (i.e. 20.04, 11.3, 10)

No response

Issue

Description:

I am currently in the process of upgrading Mongoose from version 4 to version 8 in our project, and I've encountered a significant performance issue.

Summary:

• v4 performance: Acceptable speeds.
• v8 performance: Approximately 40% slower for findOne queries, despite find queries operating as expected (and even faster than before).

Details:

• Indexes and schema remain identical between v4 and v8.
• No special configurations or optimizations were applied during the upgrade.
• find queries exhibit improved performance under v8, but findOne queries are noticeably slower.
• same setting & same environment & same index

Steps to Reproduce:

• Run the same query using findOne on both Mongoose v4 and v8.
• Compare the query performance between the two versions.

Expected Behavior:

• Performance should be on par or improved in v8, compared to v4.

Actual Behavior:

• findOne queries are approximately 30% slower in v8 than in v4.

[IslandRhythms]

Mongoose version 4.13.21 1.938ms

const mongoose = require('mongoose');


const testSchema = new mongoose.Schema({
    name: String,
    val: Number
});


const Test = mongoose.model('Test', testSchema);

async function main() {
    for (let i = 0; i < 100; i++) {
        const doc = new Test();
        doc.name = 'Test',
        doc.val = i;
        doc.save(function(err) {

        });
    }
}

async function run() {
    Test.findOne({}, function (err, doc) {
        console.log('doc', doc);
    });
}

(async () => {
    await mongoose.connect('mongodb://localhost:27017/performance-test');
    // await mongoose.connection.dropDatabase();
    await main();
    console.time('performanceTest')
    await run();
    console.timeEnd('performanceTest');
    console.log(mongoose.version)
    process.exit(0);
})();

Mongoose version 8.7.0 10.779ms

const mongoose = require('mongoose');


const testSchema = new mongoose.Schema({
    name: String,
    val: Number
});


const Test = mongoose.model('Test', testSchema);

async function main() {
    for (let i = 0; i < 100; i++) {
        await Test.create({
            name: 'Test',
            val: i
        })
    }
}

async function run() {
    const res = await Test.findOne();
    console.log(res);
}

(async () => {
    await mongoose.connect('mongodb://localhost:27017/performance-test');
    await mongoose.connection.dropDatabase();
    await main();
    console.time('performanceTest')
    await run();
    console.timeEnd('performanceTest');
    console.log(mongoose.version)
    process.exit(0);
})();

[billouboq]

if we lean the two do we get the same results ? To know if it's mongoose related or driver related

[IslandRhythms]

lean causes a +/- change of 1 ms.

[billouboq]

So might be driver related I guess