PERFORMANCE BENCHMARKS

Updated Aug 3, 12:21 PM

Benchmark Env

Schema Raw JSON

Real-world benchmark suite comparing Phi against Raw SQL, GORM, Ent, and Bun under identical workloads.

Showing: Throughput (ops/sec) - Higher is betterTarget Database: sqlite

Create

5 ORMs tested

Raw1st

69,266 ops/s

Phi3rd

52,695 ops/s

Bun4th

25,938 ops/s

Ent2nd

57,329 ops/s

GORM5th

23,179 ops/s

CreateMany

5 ORMs tested

Raw2nd

13,181 ops/s

Phi1st

15,297 ops/s

Bun3rd

9,205 ops/s

Ent4th

8,645 ops/s

GORM5th

7,451 ops/s

CreateManyAndReturn

5 ORMs tested

Raw2nd

9,062 ops/s

Phi1st

10,043 ops/s

Bun4th

7,974 ops/s

Ent3rd

8,752 ops/s

GORM5th

7,251 ops/s

CreateManyAndReturnWithDeepSelect

5 ORMs tested

Raw1st

5,171 ops/s

Phi2nd

4,719 ops/s

Bun4th

3,206 ops/s

Ent3rd

4,096 ops/s

GORM5th

3,149 ops/s

CreateWithDeepSelect

5 ORMs tested

Raw1st

30,672 ops/s

Phi2nd

17,048 ops/s

Bun4th

11,859 ops/s

Ent3rd

13,833 ops/s

GORM5th

9,813 ops/s

Delete

5 ORMs tested

Raw2nd

547 ops/s

Phi1st

564 ops/s

Bun3rd

541 ops/s

Ent5th

260 ops/s

GORM4th

529 ops/s

FindFirst

5 ORMs tested

Raw2nd

85,048 ops/s

Phi1st

123,548 ops/s

Bun3rd

59,259 ops/s

Ent4th

44,179 ops/s

GORM5th

42,245 ops/s

FindMany

5 ORMs tested

Raw2nd

23,793 ops/s

Phi1st

32,177 ops/s

Bun4th

18,799 ops/s

Ent3rd

22,470 ops/s

GORM5th

14,687 ops/s

FindUnique

5 ORMs tested

Raw2nd

85,932 ops/s

Phi1st

130,242 ops/s

Bun3rd

61,031 ops/s

Ent4th

44,126 ops/s

GORM5th

42,112 ops/s

ReadDeepRelation

5 ORMs tested

Raw2nd

29,538 ops/s

Phi1st

45,760 ops/s

Bun3rd

18,796 ops/s

Ent4th

14,290 ops/s

GORM5th

10,958 ops/s

Upsert

5 ORMs tested

Raw1st

58,899 ops/s

Phi2nd

50,426 ops/s

Bun3rd

22,931 ops/s

Ent5th

9,641 ops/s

GORM4th

18,313 ops/s

UpsertWithDeepSelect

5 ORMs tested

Raw2nd

13,425 ops/s

Phi1st

14,605 ops/s

Bun3rd

8,330 ops/s

Ent5th

3,942 ops/s

GORM4th

5,300 ops/s