Benchmark test

[arisawali2014]

I tried to benchmark it with production. Why is it slower?

Benchmark::measure([
fn() => Invoice::simplePaginate(),
fn() =>Invoice::paginate(),
fn()=>Invoice::fastPaginate()]);
= [
    252.726125,
    1597.069791,
    1705.214708,
  ]

Benchmark::measure([  
  fn() => Invoice::orderBy('created_at')->simplePaginate(),
  fn() =>Invoice::orderBy('created_at')->paginate(),
  fn()=>Invoice::orderBy('created_at')->fastPaginate()
]);
= [
    847.420583,
    3027.214792,
    3190.175208,
  ]

[4H1R]

I didn't check myself but after this Issue I've created 1 million record in the PGSQL DB and the result is the same this package is slower compared to paginate

$result = Benchmark::measure([
            fn() => \App\Models\Test::simplePaginate(200_000),
            fn() => \App\Models\Test::paginate(200_000),
            fn() => \App\Models\Test::fastPaginate(200_000)]
    );

Result

array:3 [
  0 => 821.105774
  1 => 895.605812
  2 => 2224.163781
]

Why is this package slower in benchmarks?

[aarondfrancis]

I don't think Postgres suffers from this problem.