5 years ago

Category: Laravel, PHP

I was tasked not long ago to make a tiny private prototype. Once I did it and proved my point that this what the perfect opportunity to rewrite the old application to something more microservice-esque and elastic— clients paying at the month’s end was a timeout circus — I doubted if using the Lumen framework (PHP) with a sole SQL database was enough to keep it performanant.

Most of ORM offer a way to add drivers for each RDBMS, so you can safely switch from one to another.

For example, it’s not necessary to hydrate an ORM object with data if you only need to update it, nor doing it 100 times with other data you don’t need like timestamps. So, checking benchmarks again, it’s not difficult to see that ORM overall make the application slower, compared to just using just direct connections and raw queries.