Function test

test/node/src/performance.test.ts:35–58

()

    it('simple query builder performance test', async () => {
      function test() {
        ctx.db
          .selectFrom(['person as p', 'pet'])
          .innerJoin('toy', 'toy.pet_id', 'pet.id')
          .whereRef('p.id', '=', 'pet.owner_id')
          .where('toy.id', '=', 1)
          .where('p.id', 'in', [1, 2, 3, 4, 5, 6, 7, 8, 9, 10])
          .where(({ exists, selectFrom }) =>
            exists(
              selectFrom('toy_schema.toy').whereRef(
                'toy_schema.toy.id',
                '=',
                'toy.id',
              ),
            ),
          )
          .select([
            'toy.price as price',
            sql`concat(${sql.ref('first_name')}, ' ', ${sql.ref(
              'last_name',
            )})`.as('full_name'),
          ])
          .compile()
      }

      const WARMUP_ROUNDS = 1000
      const TEST_ROUNDS = 100000