Ändra sökning
RefereraExporteraLänk till posten
Permanent länk

Direktlänk
Referera
Referensformat
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annat format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annat språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf
Comparison of performance between Raw SQL and Eloquent ORM in Laravel
Blekinge Tekniska Högskola.
Blekinge Tekniska Högskola.
2016 (Engelska)Självständigt arbete på grundnivå (kandidatexamen), 10 poäng / 15 hpStudentuppsats (Examensarbete)
Abstract [en]

Context. PHP framework Laravel offers three techniques to interact with databases, Eloquent ORM, Query builder and Raw SQL. It is important to select the right database technique when developing a web application because there are pros and cons with each approach.

 Objectives. In this thesis we will measure the performance of Raw SQL and Eloquent ORM, there is little research on which technique is faster. Intuitively, Raw SQL should be faster than Eloquent ORM, but exactly how much faster needs to be researched.

 

Methods. To measure the performance of both techniques, we developed a blog application and we ran database operations select, insert and update in both techniques.

 

Conclusions. Results indicated that overall Raw SQL performed better than Eloquent ORM in our database operations. There was a noticeable difference of average response time between Raw SQL and Eloquent ORM in all database operations. We can conclude that Eloquent ORM is good for building small to medium sized applications, where simple CRUD operations are used for the small amount of data. Typically for tasks like inserting a single row into a database or retrieving few rows from the database. Raw SQL is preferable for the applications that are dealing with huge amount of data, bulk data loads and complex queries.

Ort, förlag, år, upplaga, sidor
2016.
Nyckelord [en]
ORM, Object Relational Mapping, SQL, Database, Relational database
Nationell ämneskategori
Datavetenskap (datalogi)
Identifikatorer
URN: urn:nbn:se:bth-13232OAI: oai:DiVA.org:bth-13232DiVA, id: diva2:1014983
Ämne / kurs
PA1418 Kandidatarbete - Stort programvaruprojekt i grupp
Utbildningsprogram
PAGWE Webbprogrammering
Handledare
Examinatorer
Tillgänglig från: 2016-10-04 Skapad: 2016-10-03 Senast uppdaterad: 2018-01-14Bibliografiskt granskad

Open Access i DiVA

BTH2016Halimi(1092 kB)49937 nedladdningar
Filinformation
Filnamn FULLTEXT02.pdfFilstorlek 1092 kBChecksumma SHA-512
0c271fb98390e98caa16ff3089bbc6fd030d5fe81814d057c8e1debe045f8856d8dd032680b04195d6fea6c1eea1758529c43fbc1b06df5bd90af66d8d1566e9
Typ fulltextMimetyp application/pdf

Av organisationen
Blekinge Tekniska Högskola
Datavetenskap (datalogi)

Sök vidare utanför DiVA

GoogleGoogle Scholar
Totalt: 49939 nedladdningar
Antalet nedladdningar är summan av nedladdningar för alla fulltexter. Det kan inkludera t.ex tidigare versioner som nu inte längre är tillgängliga.

urn-nbn

Altmetricpoäng

urn-nbn
Totalt: 7437 träffar
RefereraExporteraLänk till posten
Permanent länk

Direktlänk
Referera
Referensformat
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annat format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annat språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf