ORM Benchmarking (in development)

ORM's:

• C# (.NET):
  • Entity Framework
  • raw SQL
• PHP:
  • Eloquent
  • raw SQL (PDO)
• JavaScript:
  • Sequelize
  • raw SQL

Database

We are simulating an LMS (Learning Management System). There are simplified database based on Learnin, my LMS implementation.

Each ORM have the same entities:

• User
  • which has one Student (additional information about student)
  • which has one Teacher (additional information about teacher)
  • which has many Courses
• Student
  • which belongs to one User
• Teacher
  • which belongs to one User
• Course
  • which has many Users
  • which has many Tasks
• Task
  • which belongs to one Course

Benchmark cases

1. Select queries:

• Select n first users
• Select n students and their courses order by surname
• For n students select tasks to do (with course information)

2. Insert queries:

• Insert n users with additional information (student or teacher) using transaction
• Insert n courses

3. Update queries:

• For n courses prolong available to date

4. Delete queries:

• For n users take them out of courses
• Delete n courses

Results

not done yet...

Analysis

not done yet...